hi folks,

how to calculate tablespace limits in db2?

i have some information here.could u plz resolve it?

in v8

Number of bytes used for pointing a page is 3
Number of bytes used for slot number is 1

in v9.1 & V9.5

Number of bytes used for pointing a page is 4
Number of bytes used for slot number is 2

in v9.7 these values may be increased but i donno how much exactly

Here are the limits


Page size 8.x 9.1/ 9.5 9.7
4 KB 64 GB 2 TB 8 TB
8 KB 128 GB 4 TB 16 TB
16 KB 256 GB 8 TB 32 TB
32 KB 512 GB 16 TB 64 TB

Plz modify stats if there are any faults.

The is an Appendix to the SQL Reference Vol 1 called SQL Limits that has that information.