The Db2 system monitor

The Db2 system monitor starts automatically and identifies problems related to CPU stalls and DBM1 below-the-bar storage.

The Db2 system monitor looks for CPU stalls that result in latch contention. When it detects a CPU stall, the Db2 system monitor attempts to clear the latch contention by temporarily boosting WLM priority. In addition, the system monitor issues the following messages:

• DSNV508I, to report when database services address space (ssnmDBM1) storage that is below the 2-GB bar reaches critical storage thresholds, and information about the amounts of consumed and available storage.
• A series of DSNV512I messages to identify the agents that consume the most storage.

Specify aggressive performance goals in WLM and very high importance for the ssnmMSTR address space to increase the effectiveness of the monitor.