DB2 Server for VM: System Administration

Database Maximum Values

Table 59. Database Maximum Values

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

Notes for Table 59:

1. The database extents are not limited to 26 minidisks because VM block I/O is used.
2. This is the absolute maximum size of the database. The practical maximum is lower.
3. This is the absolute maximum size of a dbspace. The practical maximum is lower.
4. A gigabyte is 2³⁰ bytes (1,073,741,824).
5. This is the absolute maximum size allowed, but it is much larger than the database can use. See Table 3 for more appropriate estimates.