Results 1 to 2 of 2

Thread: Max records

  1. #1
    Join Date
    Dec 2007
    Posts
    3

    Unanswered: Max records

    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

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by vanipreman165
    What is the maximum number of records the table can have based on the following definitions
    See the responses in http://www.idugdb2-l.org/cgi-bin/wa?...L=DB2-L&P=4524 and click on "Next in topic".
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •