Exception profiling report
Use the Exception profiling report to examine the results of exception profiling.
Example of an exception profiling report
Here is an example report of exception profiling.
The INPUT FROM and INPUT TO fields
show the date and time of the first and last record in the input data
set.
The profiling report also shows a table for
each of the fields. These tables show the calculated threshold values
(SPECIFIED THRESHOLD) and the expected number of
exceptions (EXCEPTIONS GENERATED) for various exception
percentages. These percentages are in multiples of 0.1, 0.25, 0.5,
1, 1.5, and 2 times the problem exception percentage specified in
the Exception Profiling panel. For example, if the problem percentage
is 5%, the table columns shown are 0.5%, 1.25%, 2.5%, 5%, 7.5%, and
10%.
Any error messages that are generated during exception processing are shown on the profiling report.
ACTUAL AT: 02/17/15 11:21:58.26 OMEGAMON for DB2 Performance Expert (V5R5M0) PAGE: 1
INPUT FROM: 01/02/15 06:02:12.11 EXCEPTION PROFILING REPORT
INPUT TO: 02/15/15 02:30:00.00
WARNING THRESHOLD % 10.00
PROBLEM THRESHOLD % 5.00
LOCATION CONNECT
FIELD ID REQLOC GROUP CORRNAME PLANNAME PER BY OPERATOR OCCURRENCES DESCRIPTION
FLD.QUAL SUBSYSTEMID MEMBER CORRNMBR PRIMAUTH
-------- ---------------- -------- -------- -------- -------- ------ -------- ----------- ----------------------------------------
* *
QBACGET * * * * PLAN TOTAL >
103 GETPAGES
N/A * * * *
------------------------------------------------------------------------------------------------------------------------------------
| | PROBLEM | WARNING | 0.50 % | 1.25 % | 2.50 % | 5.00 % | 7.50 % | 10.00 % |
------------------------------------------------------------------------------------------------------------------------------------
| SPECIFIED THRESHOLD | 22 | 21 | 39 | 37 | 37 | 22 | 21 | 21 |
------------------------------------------------------------------------------------------------------------------------------------
| EXCEPTIONS GENERATED | 5 | 8 | 1 | 2 | 2 | 5 | 8 | 8 |
------------------------------------------------------------------------------------------------------------------------------------
* *
SLRSUSP * * * * SYSTEM TOTAL >
150 TOTAL ALL SUSPENSIONS
N/A * * * *
------------------------------------------------------------------------------------------------------------------------------------
| | PROBLEM | WARNING | 0.50 % | 1.25 % | 2.50 % | 5.00 % | 7.50 % | 10.00 % |
------------------------------------------------------------------------------------------------------------------------------------
| SPECIFIED THRESHOLD | 423603 | 402603 | 444603 | 441603 | 435603 | 423603 | 411603 | 402603 |
------------------------------------------------------------------------------------------------------------------------------------
| EXCEPTIONS GENERATED | 8 | 15 | 1 | 2 | 4 | 8 | 12 | 15 |
------------------------------------------------------------------------------------------------------------------------------------
* *
SSCDML * * * * SYSTEM TOTAL >
150 TOTAL SQL DML STATEMENTS
N/A * * * *
------------------------------------------------------------------------------------------------------------------------------------
| | PROBLEM | WARNING | 0.50 % | 1.25 % | 2.50 % | 5.00 % | 7.50 % | 10.00 % |
------------------------------------------------------------------------------------------------------------------------------------
| SPECIFIED THRESHOLD | 1410145 | 1340145 | 1480145 | 1470145 | 1450145 | 1410145 | 1370145 | 1340145 |
------------------------------------------------------------------------------------------------------------------------------------
| EXCEPTIONS GENERATED | 8 | 15 | 1 | 2 | 4 | 8 | 12 | 15 |
------------------------------------------------------------------------------------------------------------------------------------
EXCEPTION PROFILING REPORT COMPLETE