Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Unanswered: Table space and table size limit

    HI, nice to join this forum. I'm kinda new to DB2.

    I had always believed that the max size for a tablespace with 4kb page size is 64GB for both sms tablespace. But now i have a doubt when I found my db tablespace was almost 300GB with a page size of 4KB.

    However it did give me warning when a table reached 64Gb saying "the object has reached its maximum size". Now I'm confused whether the maximum size is for tablespaces or for tables. Is it the same for both DMS and SMS tablespaces??? please share your knowledge on this.


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11


    the limits are described in the sql reference
    Table 32. Database Manager Limits
    Most columns in a table g 1 012
    Maximum size of a table per partition (in gigabytes) c g 512
    Maximum size of a regular DMS table space (in gigabytes) c g 512
    this for 4K pages..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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