Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: size limits on DMS tablespaces

    Does anyone off hand know what the size limitations are for DMS container based tablespaces in DB2 7.x? We have some very large 15Gb tablespaces and would like to do some capacity planning in advance. Thanks

    Scott

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: size limits on DMS tablespaces

    15 GB does not seem to be a problem ...


    DB2 Admin - Planning Guide , under Physical db design:

    The maximum size of regular table spaces is 64 GB for 4 KB pages; 128 GB
    for 8 KB pages; 256 GB for 16 KB pages; and 512 GB for 32 KB pages. The
    maximum size of long table spaces is 2 TB.


    Originally posted by mixxalot
    Does anyone off hand know what the size limitations are for DMS container based tablespaces in DB2 7.x? We have some very large 15Gb tablespaces and would like to do some capacity planning in advance. Thanks

    Scott
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    And those numbers are per logical node on MPP systems.

Posting Permissions

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