FP5: Table space modification status can be checked

In Version 9.7 Fix Pack 5 and later fix packs, the db2pd -tablespaces command and the MON_GET_TABLESPACE table function provide information about the modification status of table spaces. You can use this information to make better decisions about how you perform backups.

You can now specify the trackmodstate option for the db2pd -tablespaces command to display the status of the table space with respect to the last backup. In the output, a new TrackmodState column is displayed, which can have one of six values for each table space: Clean, Dirty, Incremental, ReadFull, ReadIncremental, and n/a.

The MON_GET_TABLESPACE table function is updated with a new monitor element. This new monitor element is named tbsp_trackmod_state. The tbsp_trackmod_state monitor element states what status the tablespace is in by displaying one of the six values mentioned previously, except for n/a which is replaced by UNAVAILABLE for the new monitor element.

To receive information about the modification status of table spaces, you must set the trackmod configuration parameter to Yes.