Hi,

DB2 V7 on os/390

I have tablespaces that the number of rows will grow. I am trying to
find right number of PQTY and SQTY. Sizing the first three TSs are
already done. Looking at the first three I wonder if there is any rule
to decide PQTY and SQTY based on the number of rows. Is there any rule
between the two?


TS type estimated rows PQTY SQTY

ABC Seg 200,000 14400 1440
DEF Seg 500,000 38880 4320
GHI Seg 1800,000 185040 18720
JKL Partitioned 250,000,000 ? ?


I always thank you those who respond and give me input.

James

DB2 & UDB email list listserv db2-l LazyDBA home page