Help

Observation: Inefficient Page Size for Table

The table row length and the page size of the tablespace in which you located the table conflict with their limits. DB2 permits a maximum of 255 rows per 4k page regardless of the row length. Tablespaces may use 4k, 8k, 16k, or 32k page sizes. For each size there are a fixed number of control bytes. The control byte size is significantly larger if there is an EDITPROC.

  • When the row size times 255 (maximum number of rows) is less than the tablespace page size minus control bytes, there is wasted space.

  • When the row size is slightly larger than half the page size of the tablespace that the rows are stored in, there will be only one row per page, regardless of the actual record size.

Review the row sizes of the target tables and consider combining small tables and splitting large tables to reduce the amount of wasted disk space.