Exception profiling dialog

This section describes the invocation and the dialog of exception profiling.

To use exception profiling, access the Interactive Report Facility (IRF) from the IBM OMEGAMON for Db2 Performance Expert on z/OS main menu and select option 6, (Exception profiling). The Exception Profiling panel is displayed, as shown in Figure 1.

Use the Exception Profiling panel to specify the profiling criteria required to calculate the threshold values and the required and optional data sets.

DGOFEP00                   Exception Profiling

Complete the following control information, then press Enter.

Warning exceptions........... _____  (% of input data)
Problem exceptions........... _____  (% of input data)
Produce profile report......... _      (1=yes 2=no)


Input data set
______________________________________________

Input threshold data set
______________________________________________

Output threshold data set
______________________________________________

Output report data set
______________________________________________

Command ===>
______________________________________________________________
F1=Help      F2=Split     F3=Exit      F6=Browse    F9=Swap     F10=Global
F11=Inclexcl F12=Cancel

In this panel:

• Specify the percentage of input data that you want to be flagged as warnings (for example 5.00%) and the percentage of input data that you want to be flagged as problems (for example 2.50%). The percentages can be as small as 0.01%.
• Choose whether you want to produce a profile report. The profile report documents the results of exception profiling (the expected number of exceptions for various thresholds).
• Specify the name of the input data set that contains Db2 instrumentation data from your Db2 subsystem. It can be a GTF, SMF, or DPMOUT data set.

  If you want to use several input data sets, you can concatenate them by editing the generated job stream by using option 2, Edit the generated job stream, in the Job Processing Selections panel (see Figure 2).

• Specify the name of the input threshold data set that contains entries marked by asterisks (*) for the fields that you want to be profiled.
• Specify the name of the output threshold data set that will contain the results.
• If you requested a profile report, specify the name of the output report data set.

After you have completed the specifications, press Enter to generate the exception profiling job stream. The Job Processing Selections panel is displayed.

DGOOJOBM                   Job Processing Selections
Command ===> __________________________________________________________________

Update the job statements as required, then select one of the following.

4  1. Browse the generated job stream
   2. Edit the generated job stream
   3. Store the job stream for future use
   4. Submit the job stream for background execution


Job statement information:
//USERP01P JOB (D01,CHAT),'USR USERP21',MSGCLASS=V,CLASS=D,_____________
//            REGION=0M,NOTIFY=USERP01__________________________________
________________________________________________________________________
________________________________________________________________________
________________________________________________________________________






Command ===> ____________________________________________________________________
 F1=Help    F2=Split   F3=Exit    F9=Swap   F12=Cancel

To submit the job, select option 4, enter your appropriate job statement information, and press Enter. Alternatively, you can browse, edit, or store the job stream for subsequent processing.

The new Exception Threshold data set is created.

Check the profiling report to ensure that the exception thresholds and the number of exceptions are satisfactory. If necessary, you can modify the threshold values in the new Exception Threshold data set, as described in Specifying exceptions using the Exception Threshold data set editor.

Now you can generate exception reports using the new Exception Threshold data set created by the exception profiling function.