SpaceLeft (DB2_TSP)

This parameter indicates the amount of free space (in megabytes) in the selected tablespace.

Note: 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 System Managed Space (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

In an SMS tablespace, the operating system's file system manager allocates and manages the space where the tables are stored. The storage model typically consists of many files, representing table objects, stored in the file system space. You can decide the location of the files, DB2 Universal Database controls, their names, and the file system is responsible for managing them. By controlling the amount of data written to each file, the Database Manager distributes the data evenly across the tablespace containers. Space is not allocated by the system until it is required.

SMS tablespaces are not auto-resizable.

Normal Tablespace:

For DMS tablespace

In a DMS (Database Managed Space) tablespace, the Database Manager controls the storage space. The storage model consists of a limited number of devices or files for which space is managed by DB2 Universal Database (DB2 UDB). The database administrator decides which devices and files to use, and DB2 UDB manages the space on those devices and files. For a DMS tablespace, space is allocated when the tablespace is created.

Normal Tablespace:

Usable Pages is the total filesystem size of the operating system where tablespace containers are allocated divided by PageSize.

Auto-resize Tablespace with MAXSIZE:

Auto-resize specifies whether or not the auto-resize capability of a DMS tablespace is to be enabled. Auto-resizable tablespaces automatically increase in size when they become full.

MAXSIZE specifies the maximum size to which a tablespace that is enabled for auto-resize can automatically increase. If the tablespace is auto-resizable, but the MAXSIZE clause is not specified, the default is NONE.

One of the following formulas is used:

Or

First formula is used when (MAXSIZE / Page Size) is lower than (Free space on the file system containing tablespace containers (in KB)/ Page Size). Else, the second formula is used.

Auto-resize Tablespace without MAXSIZE:

Note: For information about the tablespace types and percentage of the tablespace pages that are used on the current node, see the PctPagesUsedPctPagesUsed parameter.

Default parameter attributes