DB2 Server for VSE: System Administration

Database Maximum Values

Table 56. Database Maximum Values

Restricted Parameter	Maximum
Number of storage pools Number of dbextents Number of dbspaces   Number of bytes per database 1 Number of pages per database 1   Number of bytes per dbspace 2 Number of pages per dbspace 2   Size of the directory Size of a log 4 Size of a dbextent Size of a storage pool 1	999 999 32000   64 gigabytes 3 16,777,088   32 gigabytes 3 8,388,480   1,048,575 4KB pages 524,287 4KB pages 1,048,575 4KB pages 64 gigabytes 3

Notes for Table 56:

1. This is the absolute maximum size of the database. The practical maximum is lower.
2. This is the absolute maximum size of a dbspace. The practical maximum is lower.
3. A gigabyte is 2³⁰ bytes (1,073,741,824).
4. This is the absolute maximum size allowed, but it is much larger than the database can use. See Table 4 for more appropriate estimates.