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.

Thanks.

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..