Exception Log

This topic provides details about the Exception log.

The exception log identifies and lists Accounting and Statistics records with at least one field outside user-specified limits. You can use it to identify DB2® threads and Statistics intervals that contain fields with exceptional values. This helps you recognize performance problems in the DB2 subsystem and in threads.

Exception processing is accomplished by setting values in the exception threshold data set. You can define exception thresholds for specific Accounting and Statistics fields. When exception processing is requested, the instrumentation data is checked against these values. Only records with at least one field containing a value outside the user-specified limits are reported.

The exception log file data set is a sequential data set suitable for use by the DB2 load utility. It contains a listing of Accounting and Statistics exception records identical to the listing in the exception log.

Exception traces are available in the Accounting and Statistics report sets. Each of these relates separately to accounting or statistics data. The exception log reports Accounting and Statistics trace exceptions in the same report, in timestamp order. This helps you identify:

• Applications that might be causing exceptional conditions in the DB2 subsystem
• Exceptional DB2 subsystem conditions that might be causing thread performance problems

Although Accounting and Statistics exception reports are available in addition to traces, report entries are neither listed in the exception log nor stored in the exception log file data set.

Input to Exception Logs

DB2 Statistics and Accounting trace records with IFCID 001 and 002 (statistics) and IFCID 003 and 239 (accounting) are used as input to the exception log.