Db2 for z/OS searches
The name for each Db2® for z/OS® sample search is shown with a brief description of what the associated query looks for.
- Db2 Action, Decision, or Error Messages
- Searches for Db2 messages that indicate any of the
following situations:
- Immediate action is required.
- A decision is required.
- An error occurred.
- Db2 Data Set Messages
- Searches for Db2 messages that indicate any of the
following situations:
- Failure of a data set definition
- Failure of a data set extend
- Impending space shortage
- Db2 Data Sharing Messages
- Searches for internal resource lock manager (IRLM) messages that were issued to Db2 and that indicate at least one of the following situations:
- The percentage of available lock structure capacity is low.
- An error occurred when IRLM used the specified z/OS automatic restart manager (ARM) function.
- Db2 Job Performance
- Searches for records that have a program name of
DSNYASCPorDSNADMT0. - Db2 Lock Conflict Messages
- Searches for Db2 messages that indicate that a plan was denied an IRLM lock due to a detected deadlock or timeout.
- Db2 Log Data Set Messages
- Searches for messages that indicate that Db2 log data sets are full, are becoming full, or could not be allocated.
- Db2 Log Frequency Messages
- Searches for Db2 messages that indicate that log archives were offloaded or are waiting to be offloaded.
- Db2 Messages
- Searches for Db2 messages, which start with the prefix
DSN. - Db2 Pool Shortage Messages
- Searches for Db2 messages that indicate that the amount of storage in the group buffer pool (GBP) coupling facility structure that is available for writing new pages is low or critically low.