Output from exception reporting

Exception processing provides several types of output as part of Accounting and Statistics reporting.

Exception reports, traces, and files are obtained using the EXCEPTION subcommand option in the ACCOUNTING and STATISTICS commands.

Reports and traces

Exception reports and traces are like the usual Accounting and Statistics reports and traces, except that they only contain records that have at least one field in exception status.

Logs

Exception logs combine both Accounting and Statistics fields that are in exception status into a single report and show the information in timestamp order.

File data sets and Log File data sets

The Exception File data set and the Exception Log File data set are sequential data sets that are suitable for use by the Db2 load utility. The Exception File data set contains Accounting or Statistics records that have at least one field in exception status. The Exception Log File data set contains both Accounting and Statistics fields that are in exception status. The Exception File data set corresponds to an exception trace, whereas the Exception Log File data set corresponds to an exception log.

The Exception Log data set is written if you define the EXTRCDD1 DD statement in the JCL. To prevent the generation of the Exception Log data set, omit the EXTRCDD1 statement from your JCL (the preferred method), or specify DUMMY in the definition.

The Exception Log File data set is written if you define the EXFILDD1 DD statement in the JCL. To prevent the generation of the Exception Log File data set, omit the EXFILDD1 statement from your JCL (the preferred method), or specify DUMMY in the definition.