Hi

Can some body suggest me what are the advantages of using long/large tablespaces Vs regular tablespaces.

How we can make use of long tablespaces in Db2 version 9

Thanks

With LARGE tablespaces, you have bigger RID and, thus, may fit more rows onto a single page. The basic things are explained in the manual and also how to use it: http://publib.boulder.ibm.com/infoce.../r0000929.html

(This is the V9.5 manual - so you may want to have a look at the manual for your DB2 version.)