You can use the exception profiling method to set adequate exception threshold values based on sample DB2 instrumentation data. This method eases the process of getting a suitable Exception Threshold data set that can be used for exception processing.
The basic procedure is to use an existing Exception Threshold data set, mark those fields that you want to be profiled by an asterisk (*), specify generalized warning and problem exception levels, and let the exception profiling batch job do the calculations based on the sample instrumentation data. The result is a new Exception Threshold data set with adequate exception threshold values.
Exception profiling can be repeated by using different sample data, or different field selections, or different generalized exception levels. An Exception Threshold data set can also be modified as described in Specifying exceptions using the Exception Threshold data set editor.