Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    10

    Unhappy Unanswered: maximum number of pages in a table space?

    hi folks,

    how to calculate tablespace limits in db2?

    i have some information here.could u plz resolve it?

    in v8

    Number of bytes used for pointing a page is 3
    Number of bytes used for slot number is 1

    in v9.1 & V9.5

    Number of bytes used for pointing a page is 4
    Number of bytes used for slot number is 2

    in v9.7 these values may be increased but i donno how much exactly

    Here are the limits


    Page size 8.x 9.1/ 9.5 9.7
    4 KB 64 GB 2 TB 8 TB
    8 KB 128 GB 4 TB 16 TB
    16 KB 256 GB 8 TB 32 TB
    32 KB 512 GB 16 TB 64 TB

    Plz modify stats if there are any faults.
    Last edited by jagdis_vishnu; 08-26-11 at 15:21. Reason: content addition

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The is an Appendix to the SQL Reference Vol 1 called SQL Limits that has that information.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Tags for this Thread

Posting Permissions

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