In DB2 databases, the size of tables and tablespaces is limited by pagesize and corresponding addressing capabilities. This article will give you a detailed analysis of the restrictions on the size of tables and tablespaces In the DB2 database for your reference.
In DB2 v8, the page address is 3 bytes, that is, the 24 power of 2 is available, that is, 16,777,216 pages can be addressable. Based on this restriction, the following table space and table size restrictions are obtained:
# Of pages Page size Limit of table/tablespace
16,777,216 4 K 64 GB
16,777,216 8k 128 GB
16,777,216 16k 256 GB
16,777,216 32 K 512 GB
In DB2 v9, the page address is expanded to 4 bytes, that is, the addressing capability is increased by 4 times. The specific restrictions are as follows:
# Of pages Page size Limit of table/tablespace
536,870,912 4 K 2 TB
536,870,912 8 K 4 TB
536,870,912 16 K 8 TB
536,870,912 32 K 16 TB
Note: in DB2 v8, the large tablespace is only used by the LOB and LONG data types, but there is no similar restriction in DB2 v9. The default tablespace type is large, if you upgrade from DB2 v8 to v9, You need to manually convert the tablespace from regular to large.
Alter tablespace tablespace_name CONVERT TO LARGE
Typical errors in DB2 v8