SMS or DMS

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

Answers inline:

netzorro wrote:
> 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.

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

Yes, if reorgchk says to do this.

> 
> Thanks
> Diego
> 

netzorro wrote:

> 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.

-- 
Knut Stolze
DB2 z/OS Utilities Development