DB2 table size

[Yoramsamuel]

what is the table size limit in DB2 version 7.1 ?

 

[blom0344]

I recall that object size is related to tablespace type (SMS,DMS) and that DMS tablespaces can hold objects up to 4Gb. I do not think the restriction exists for SMS tablespaces

Ties Blom
Information analyst

 

[gregsimpson]

Found the following on V8 (appreciate you're after V7). A good link none the less.

http://publib.boulder.ibm.com/infoc...topic=/com.ibm.db2.udb.doc/admin/r0001029.htm

Maximum size of a regular DMS table space (in gigabytes) c g 512
Maximum size of a long DMS table space (in terabytes) c 2
Maximum size of a temporary DMS table space (in terabytes) c 2

Seems to agree with Ties assumption s regards DMS and SMS, with the exception that V8 has different DMS limits to V7.

Cheers
Greg

 

[juliane26]

In V7.2:

regular DMS with 32K pagesize: 512 GB
long DMS tablespace: 2 TB
temporary DMS tablespace: 2 TB

Didn't find any restrictions on SMS tablespaces, only table size per partition is limited to 512GB.

see also Appendix A: SQL Limits:
ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/pdf/letter/db2s0e71.pdf



Juliane