DB2 tablespace size limit

The size of the DB2 tablespace is not infinite. In the DB2 world, the size of the table and DB2 tablespace is mainly limited by pagesize and its corresponding addressing capabilities.

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 DB2 tablespace of the large type is only used by the LOB and LONG data types, but there is no similar restriction in DB2 v9. The default DB2 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

Batch import of DB2 stored procedures

How to create a temporary DB2 table

DB2 connection Server Configuration

Learn about the DB2 lock types

Solution to db2 tablespace lock