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.
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 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be