Group-Scope Traces and Reports
In group-scope traces, events are reported in a chronological sequence within the DB2® data sharing group, regardless of which member of the group actually generated the events.
The member name is printed in the body of the trace for each reported event, so that it is easy to see the member where the event occurred. Similarly, group-scope reports show events that are aggregated by the OMEGAMON for Db2 Performance Expert identifiers you specified. Data in group-scope reports is presented by member.
The information in this section is only applicable to DB2 data sharing environments.
Note: For an introduction to the Locking report set and general locking
information refer to the Reporting User's Guide.
Group-Scope Locking Report
You can generate a Group-Scope Locking report as follows:
LOCKING
REPORT
SCOPE (GROUP)
LEVEL (SUSPENSION)
This is an example of a Group-Scope Locking report:
LOCATION: USIBMSYSTDB2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: USIBMSYSTDB2 LOCKING REPORT - SUSPENSION REQUESTED FROM: NOT SPECIFIED
TO: NOT SPECIFIED
ORDER: DATABASE-PAGESET INTERVAL FROM: 01/30/15 19:32:58.89
DB2 VERSION: V10 SCOPE: GROUP TO: 01/30/15 19:56:04.31
DATABASE --SUSPEND REASONS-- ---------- R E S U M E R E A S O N S -----------
PAGESET --- L O C K R E S O U R C E --- TOTAL LOCAL GLOB. S.NFY ---- NORMAL ---- TIMEOUT/CANCEL --- DEADLOCK ---
MEMBER TYPE NAME SUSPENDS LATCH IRLMQ OTHER NMBR AET NMBR AET NMBR AET
------------------ --------- ----------------------- -------- ----- ----- ----- ---- ----------- ---- ----------- ---- -----------
'BLANK'
'BLANK'
SSDQ ALTERBUF BPID=BP0 5 0 0 0 5 0.001645 0 N/C 0 N/C
0 0 5
SCA ACCS N/A 2 0 0 0 2 0.001674 0 N/C 0 N/C
0 0 2
** SUM OF SSDQ ** 7 0 0 0 7 0.001653 0 N/C 0 N/C
0 0 7
V53B GBP CAST BPID=GBP2 1 0 0 0 1 0.001395 0 N/C 0 N/C
0 0 1
GBP S/S BPID=GBP0 3 0 0 0 3 0.002451 0 N/C 0 N/C
0 0 3
** SUM OF V41B ** 4 0 0 0 4 0.002187 0 N/C 0 N/C
0 0 4
*GROUP TOTAL*
'BLANK' 11 0 0 0 11 0.001847 0 N/C 0 N/C
0 0 11
TPCCE1
TCUST000
SSDQ OPENLOCK N/P 1 0 0 0 1 0.001677 0 N/C 0 N/C
0 0 1
AUSDB01
SYDPS01
SSDQ TREEPLCK N/P 1 0 0 0 1 0.001445 0 N/C 0 N/C
0 0 1
V53B P/P PLCK PAGE=X'80000000' 2 0 0 0 2 8.240814 0 N/C 0 N/C
BPID=BP2 0 0 2
*GROUP TOTAL*
SYDPS01 3 0 0 0 3 5.494357 0 N/C 0 N/C
0 0 3
SYDPS02
V53B P/P CAST BPID=BP2 1 0 0 0 1 16.776381 0 N/C 0 N/C
0 0 1
*TOTAL*
AUSDB01 4 0 0 0 4 8.314863 0 N/C 0 N/C
0 0 4
*GRAND TOTAL* 16 0 0 0 16 2.080090 0 N/C 0 N/C
0 0 16