Page, table and table space size
For DMS, temporary DMS and nontemporary automatic storage table spaces, the page size you choose for your database determines the upper limit for the table space size. For tables in SMS and temporary automatic storage table spaces, page size constrains the size of the tables themselves.
You can use a 4K, 8K, 16K or 32K page size limit. Each of these page sizes also has maximums for each of the table space types that you must adhere to.
Table 1 shows the table space
size limits for DMS and nontemporary automatic storage table spaces,
by page size:
Table space type | 4K page size limit | 8K page size limit | 16K page size limit | 32K page size limit |
---|---|---|---|---|
DMS and nontemporary automatic storage table spaces (regular) | 64G | 128G | 256G | 512G |
DMS, temporary DMS and nontemporary automatic storage table spaces (large) | 8192G | 16 384G | 32 768G | 65 536G |
Table 2 shows the table size
limits tables in SMS and temporary automatic storage table spaces,
by page size:
For database and index page size limits for the different
types of table spaces, see the database manager page size-specific
limits in SQL and XML limits.
Table space type | 4K page size limit | 8K page size limit | 16K page size limit | 32K page size limit |
---|---|---|---|---|
SMS | 64G | 128G | 256G | 512G |
Temporary SMS, temporary automatic storage | 8192G | 16 384G | 32 768G | 65 536G |