Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004

    Cool Unanswered: Avg Row Length - Before table creation

    From the physical model of a DB2 UDB database is it possible to determine the page size that can be used for a particular table?
    Because after the table is created I can check the average row length from AVGCOLLEN of SYSSTAT.COLUMNS.

    At present the problem which I'm facing is After generating the DDL from physical data model some table fails to get created in my database as it needs 8K or 16K pagesize. So how can I determine the avg row length before table creation process itself.
    Any help appreciate.


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    I do not think that when you are creating a new table that "average row length" has anything to do with what page size is needed. It is determined by maximum row length. Just add up all the lengths of all the columns in your definition and that should help you to determine what page size to use.


  3. #3
    Join Date
    May 2003
    Also note that the maximum usable space in a 4K page for row data is about 4000 bytes, and not 4096.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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