DB2 Version 9.7 for Linux, UNIX, and Windows

tbsp_trackmod_state - Table space trackmod state monitor element

The modification state that a table space is in with respect to the last or next backup.

Table 1. Table function monitoring information
Table function	Monitor element collection level
MON_GET_TABLESPACE table function - Get table space metrics	Always

Usage

You can use this monitor element to determine the modification status of a table space. The status of a table space can be in one of the following states:

CLEAN: No modifications occurred in the tablespace since the previous backup. If an incremental or delta backup is executed at this time, no data pages from this tablespace would be backed up.
DIRTY: Table space contains data that needs to be picked up by the next backup.
ININCREMENTAL: Table space contains modifications that were copied into an incremental backup. This state is in a DIRTY state relative to a full backup such that a future incremental backup needs to include some pages from this pool. This state is also in a CLEAN state such that a future delta backup does not need to include any pages from this pool.
READFULL: The latest table space modification state change was caused by a dirty table space that is being read by a full backup that might not have completed successfully, or is currently in progress.
READINCREMENTAL: The latest table space modification state change was caused by a dirty table space that is being read by an incremental backup that might not have completed successfully, or is currently in progress.
UNAVAILABLE: The trackmod configuration parameter is set to No. Therefore, no table space modification status information is available.