Viewing a list of exceptions
On EZDB2, hyperlink on Current Exceptions.An overview of background sampler system exceptions, thread exceptions, and outstanding messages for monitors in warning status is displayed.
W1 =STEXC===========(ALL======*=======)10MAR2011==08:51:39====MVDB2====D====7
Db2 Warning System Thread
Target Monitors Exceptions Exceptions Warning Msg
DEDM 3 0 7 RunawayQuery
DEEN 0 0 0
DEFG 2 0 1 RunawayQuery
DIT1 0 0 0
DIT2 0 0 0
QADHW2 0 0 0 Connect Fail
QADIB2 0 0 0This view identifies immediately whether any exceptions have been detected, and shows the types detected. Hyperlinks lead to additional details.
- Warning Monitors indicates the number of conditions that have been detected by timer-driven sampling monitors defined with warning thresholds. Typically, a predefined group of monitors is started automatically and remains active.
- System Exceptions are conditions that are detected by a background sampler and are not governed by a threshold (for example, a problem with log archiving).
Thread Exceptions are thread-related conditions that a background sampler detects. Threshold conditions can be defined per attach type (for example, IBM IMS , CICS, or batch).
The first three types generate warning messages that can be viewed while active, tracked historically in the journal log, or fed into an automated operator product like .
- Warning Msg shows the most important of several conditions that are checked per interval or on request, as part of the total Db2 status and statistics data collection for windows mode views. These conditions can also be identified by one of the other exception samplers.
To see exception conditions that background samplers have detected, hyperlink on either the Thread Exceptions or System Exceptions column.
>W1 =STMONEX==========(ALL======*=======)10MAR2011==08:54:51====MVDB2====D===15
+ . Warnings(DMWARN) . Alerts . Alarms
Db2 Exceptn Mon Monitor Message Message
Target-- Time Name Parm ID Text
DEFG 08:54:50 UCPU DZ0650W RUNAWAY CAF USER BOLDJW1 CPU-TOTAL=12
DEDM 08:54:50 UCPU DZ0620W RUNAWAY CICS TRANSACTION USER BOLWTN1
DEFG 08:54:45 UCPU DZ0620W RUNAWAY CICS TRANSACTION USER BOLWTN1
DEDM 08:54:25 UCPU DZ0670W RUNAWAY DBAT USER BOLDJW1 GETPAGES=70
DEDM 08:49:00 @ELTM CICS NO CICS DB2 Workload(CICS) = 2.627 (>2.
DEFG 08:44:00 RIDUT DS0620W RID POOL % UTILIZATION(TOTAL) = 100
DEDM 08:17:00 THDAB DS0130W ROLLBACK REQUESTS(TOTAL) = 23 IN 01:0
DEFG 08:17:00 THDAB DS0130W ROLLBACK REQUESTS(TOTAL) = 32 IN 01:0
DEDM 08:13:00 @ELTM DBATDRDA NO DBAT DRDA Workload(DBATDRDA) = 2.290
DEFG 08:13:00 @ELTM DBATDRDA NO DBAT DRDA Workload(DBATDRDA) = 2.245
DEDM 07:33:11 UCPU DZ0630W RUNAWAY TSO QUERY USER BOLHHH2 CPU-TO
DEDM 06:37:00 @ELTM RRSAF NO RRSAF DRDA Workload(RRSAF) = 1.697 (
DEDM 06:37:00 @ELTM CAF NO CAF DB2 Workload(CAF) = 0.748 (>0.27
DEDM 17:05:41 UCPU DZ0630W RUNAWAY TSO QUERY USER BAOBPL1 GETPAG
DEDM 16:15:48 UCPU DZ0630W RUNAWAY TSO QUERY USER BAOBPL3 CPU-TOScroll to the right to see more of the message text. For an explanation of the message, you can hyperlink on the Message ID column.
For exceptions related to specific threads (DZ06nnn messages), the Mon Name column hyperlinks to the active thread view THDACTV. For most other exceptions, the Mon Name column hyperlinks to a plot view.
- Press F3 to return to STEXC.