SMS or DMS

[netzorro]

Hi all,
without considering DMS in a device, normally, the simplest choices are SMS
or DMS in files.
Is there any performance improvement using a DMS tablepsace container in a
file instead of a SMS ?

Also, if a SMS tablespace container is used, does it make sense to
reorganize the tables?

Thanks
Diego

[Blair Kenneth Adamache]

Post by netzorro
Hi all,
without considering DMS in a device, normally, the simplest choices are SMS
or DMS in files.
Is there any performance improvement using a DMS tablepsace container in a
file instead of a SMS ?

Not really, excepts for the catalogs, and to allow lobs to be cached in
filesystem memory. Generally, I would recommend automated storage with
DB2 in DMS files.

Post by netzorro
Also, if a SMS tablespace container is used, does it make sense to
reorganize the tables?

Yes, if reorgchk says to do this.

Post by netzorro
Thanks
Diego

[Knut Stolze]

Post by netzorro
Hi all,
without considering DMS in a device, normally, the simplest choices are
SMS or DMS in files.
Is there any performance improvement using a DMS tablepsace container in a
file instead of a SMS ?

SMS grows and shrinks on demand while DMS uses pre-allocated files. The
growing of SMS containers may have a slight impact on performance. But I
doubt this will have a measurable impact on real-world applications.