Hi all,

What is the maximum number of records the table can have based on the following definitions

AVGRECLEN - 138 from SYSTABLEPART

CREATE TABLESPACE TSBLNHST IN AFSDB
USING STOGROUP SGAFS
PRIQTY 200
SECQTY 60
ERASE NO
FREEPAGE 0
PCTFREE 0
BUFFERPOOL BP1
SEGSIZE 32

From the Admin Guide Ver 8, Chapter 7 I have calculated as follows.

Maximum space allocated = (Pqty + (sqty * 251))
= 200 + 60 * 251 =15260 KB
No of pages = 15260 / 4 = 3815
Records per page = 4056/138 = 29
No of records = 3815 * 29 = 1,10,635 max

Please let me know whether my approach is correct to find the maximum no records.

The table now has reached 119 extents and have 14,10,515 records. So I am not sure what I am m issing here.

Thanks,
Vanitha

See the responses in http://www.idugdb2-l.org/cgi-bin/wa?...L=DB2-L&P=4524 and click on "Next in topic".