Example of a group-scope Locking report
In group-scope reports, events are aggregated by user-defined identifiers within the group, regardless of which member of the group actually generated the events.
To generate a group-scope Locking report, specify the following command stream:
⋮
LOCKING
REPORT
LEVEL (LOCKOUT)
SCOPE (GROUP)
⋮
The default order of a group-scope report is DATABASE-PAGESET.
Group-scope Locking Lockout report for DSHGRPXX
The following example shows a group-scope Locking report for the same group, DSHGRPXX, as in the previous member-scope example. This report summarizes the lockout activity for both members FIRST and SECOND. The information is summarized by database, then page set, and lastly by individual member.
A group total is
printed for the entire group when the database that is being monitored
changes. GRAND TOTAL shows the timeouts and deadlocks
in all databases for the entire group.
LOCATION: SYDNEY OMEGAMON for DB2 Performance Expert (V5R5M0) PAGE: 1-1
GROUP: DSHGRPXX REQUESTED FROM: NOT SPECIFIED
LOCKING REPORT - LOCKOUT TO: NOT SPECIFIED
ORDER: DATABASE-PAGESET ACTUAL FROM: 05/15/15 12:15:00.21
DB2 VERSION: V10 SCOPE: GROUP TO: 05/15/15 13:27:56.09
DATABASE
PAGESET --- L O C K R E S O U R C E --- --------------- A G E N T S ----------------
MEMBER TYPE NAME TIMEOUTS DEADLOCKS MEMBER PLANNAME CONNECT CORRNAME CORRNMBR HOLDER WAITER
------------------ --------- ----------------------- -------- --------- -------- -------- -------- -------- -------- ------ ------
DBASE9
TSPACEXX
FIRST ROW PAGE=X'000021' 0 3 FIRST D3APP01 BATCH RUNPR01 'BLANK' 2 1
ROW =X'03' SECOND D3APPBB BATCH RUNPRBB 'BLANK' 1 1
SECOND D3APPDD BATCH RUNPRDD 'BLANK' 0 2
INDEXPAGE PAGE=X'002393' 0 1 FIRST D3APP02 BATCH RUNPR02 'BLANK' 0 1
SUBP=X'01'
** LOCKOUTS FOR FIRST ** 0 4
SECOND ROW PAGE=X'000021' 0 4 FIRST D3APP01 BATCH RUNPR01 'BLANK' 2 1
ROW =X'03' FIRST D3APP02 BATCH RUNPR02 'BLANK' 1 1
SECOND D3APPAA BATCH RUNPRAA 'BLANK' 0 2
SECOND D3APPBB BATCH RUNPRBB 'BLANK' 1 1
** LOCKOUTS FOR SECOND ** 0 4
** GROUP TOTAL ** 0 8
DBASE10
TSPACEZZ
FIRST DATAPAGE PAGE=X'000055' 0 3 FIRST D3APP03 BATCH RUNPR03 'BLANK' 2 1
FIRST D3APP05 BATCH RUNPR05 'BLANK' 0 3
** LOCKOUTS FOR FIRST ** 0 3
SECOND ROW PAGE=X'000021' 0 4 FIRST D3APP01 BATCH RUNPR01 'BLANK' 1 0
ROW =X'03' FIRST D3APP02 BATCH RUNPR02 'BLANK' 0 1
SECOND D3APPCC BATCH RUNPRCC 'BLANK' 2 1
SECOND D3APPEE BATCH RUNPREE 'BLANK' 0 2
INDEXPAGE PAGE=X'000033' 0 5 SECOND D3APPBB BATCH RUNPRBB 'BLANK' 1 1
SUBP=X'03' SECOND D3APPCC BATCH RUNPRCC 'BLANK' 1 0
SECOND D3APPDD BATCH RUNPRDD 'BLANK' 0 2
** LOCKOUTS FOR SECOND ** 0 5
** GROUP TOTAL ** 0 8
** GRAND TOTAL ** 0 16