Using Statistics and Accounting reports to identify exceptions

Exception reporting is a very effective way to identify performance problems. Exception reporting identifies Db2 threads and Statistics intervals with fields that contain values outside defined thresholds. This helps you manage performance objectives by highlighting problems in the DB2 subsystem, such as applications that are experiencing exceptional conditions or DB2 subsystem conditions that are causing thread performance problems.

You should run Accounting and Statistics exception reports as part of your regular monitoring. Exception reporting is also available in the Online Monitor.

The thresholds are set in the Exception Threshold data set. You can define exception thresholds for a number of fields on a plan or program basis (commonly known as accounting or thread fields) and on a system basis (known as statistics fields). When you request exception reporting, the input data is checked against these values. Only records with at least one field outside a threshold are reported.