Db2 Message Situations

Use the series of predefined situations associated with the Db2 Message workspace to begin monitoring your system immediately or use them as templates for creating your own situations.

The names, descriptions, logic, and threshold values for the situations follow.

KD5_DSNP001I_Space_Warning monitors data sets for impending space shortages. A warning condition is detected when Db2 generates message DSNP001I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNP001I'

KD5_DSNP007I_Space_Critical monitors dataset extensions that failed with a return code and with a thread ID. A critical condition is detected when Db2 generates message DSNP007I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNP007I'

KD5_DSNT375I_Deadlock_Critical monitors deadlocks. A critical condition is detected when Db2 generates message DSNT375I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNT375I'

KD5_DSNT376I_Timeout_Critical monitors timeouts for threads that exceed the specified wait time for a locked resource. A critical condition is detected when Db2 generates message DSNT376I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNT376I'

KD5_DSNT500I_ResUnavail_Warning provides the reason, the resource type, and the name for an unavailable resource. A warning condition is detected when Db2 generates message DSNT500I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNT500I'

KD5_DSNT501I_ResUnavail_Warning provides the thread ID, the reason, the resource type, and the name for an unavailable resource. A warning condition is detected when Db2 generates message DSNT501I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNT501I'

KD5_DSNU511I_Recovery_Critical warns if an object is not recoverable when recovery is requested. A critical condition is detected when Db2 generates message DSNU511I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNU511I'

KD5_DSNU548I_Recovery_Critical warns of a RECOVER utility job in which the DBID and the PSID in the header do not match the Db2 catalog (job ends with return code 8). A critical condition is detected when DB2 generates message DSNU548I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNU548I'

KD5_DSNU621I_Runstats_Critical warn of a RUNSTATS commit or rollback that failed. A critical condition is detected when Db2 generates message DSNU621I. The situation's formula is:

DB2_Message.Message_ID EQ 'DSNU621I'