The AUTORESIZE feature - it should be called AUTOINCREMENT for DMS -
is a built-in-feature for SMS because the OS manages the files - the
only limits are based on filesize (use more containers) and filesystem
size (use more containers).

SMS is (for me) the chioce when having much dynamic traffic (create -
mass insert - drop) with tables.
The problem with DMS and AUTOresize is, that if the tablespace (TS)
grows and tables are dropped, the size remains. There is no "good" way
to decrease the size of the DMS-TS (this should be changed in version
9.5).

We have a DB with DMS (created by Performance Expert) and a very big
DMS (due to some "features" of PE) because of big tables. They now are
quite empty, but the size of the DMS can't be reduced accordingly. (We
have version 8) Even a reorg didn't help...

This won't be the case when using SMS.

All the other disadvantages of DMS to SMS disappeared since version 7,
and the reason for having 1 TS for 1 table also, because the LOAD
command was inproved (TS was unusable after some LOAD failures).

* because of AUTORESIZE
* large TS
* get information about table data and index size (before db2pd you
were lost with DMS - with SMS you just scanned the files of the table
in the filesystem)

For recovery purposes (minimum restore object is TS) you can use
export (slow) or High Performance Unload (HPU) to backup/retrieve
tables. HPU can also extract tables from a backup set into files for a
LOAD operation - thats great.

And the last thing: Since version 9 a TS can be restored to a
different one. Up to version 8 it was only allowed to restore a TS
into the SAME TS - bad thing if it was dropped (or another DB).

For me there are still some reasons to stay at SMS:
* real autoresize
* use "free space" in the filesystems for temporary tablespaces (OK
there won't be any left if the FS gets full, but this situation should
be avoided anyway)

The list became shorter and shorter since we started with version 7...


On Jan 4, 2:18*am, alexhguerra <alexhgue... (AT) uol (DOT) com.br> wrote: