PctPagesUsed (DB2_TSP)

Indicates the percentage of tablespace pages that are used. For DMS tablespaces, the parameter calculates the percentage of preallocated space that is used. For SMS tablespaces, the parameter calculates the percentage of space used by the tablespace containers on the filesystems. For DMS table spaces, this parameter calculates the percentage of the pre-allocated space that is used. Recovery action upon alarm is available.

For this parameter to be online, you need to set the monitor switch, DFT_MON_BUFPOOL to ON. Log on as the instance owner, and execute the following command:

db2 update dbm cfg using DFT_MON_BUFPOOL ON

DB2 instance must be restarted to take effect.

Note: This parameter will be offline for SMS tablespaces if the configured monitoring default account for the DB2 instance does not have read permissions to its tablespace container directories.

Parameter value calculation

For SMS Tablespace

Normal Tablespace:

For example: For the following tablespace snapshot output

And the following df-k UNIX output

For DMS Tablespace

Normal Tablespace

For example: for the following tablespace snapshot output

Auto-resize Tablespace with MAXSIZE:

N is the lowest value between (MAXSIZE/Page Size) and

MAXSIZE is the maximum tablespace size in bytes. You can use the tablespace snapshot output to obtain this value.

Note: You can specify the MAXSIZE value while creating a DMS tablespace. This value is the maximum limit a DMS tablespace can grow to.

Auto-resize Tablespace without MAXSIZE:

Default parameter attributes