Locking Detail Report
The Locking Detail (also referred to as Lock Detail) report is based on IFCID 21, which records the detail lock requests.
The Locking Detail report is produced if level DETAIL is specified in the REPORT subcommand.
The ORDER subcommand specifies by which OMEGAMON for Db2® PE identifiers the report is to be sorted. In this sample the data is accumulated and ordered by DATABASE-PAGESET.
Layout of a Locking Detail Report shows the layout of a Locking Detail report. The letter x is a placeholder marking the maximum size of a field. See Locking Detail Report for an example of a Locking Detail report.
Note: For an introduction to the Locking report set and general locking information refer to the
Reporting User's
Guide.
Layout of a Locking Detail Report
You can generate a Locking Detail report as follows:
LOCKING
REPORT
SCOPE (MEMBER)
LEVEL (DETAIL)
LOCATION: xxxx IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: X-Y
GROUP: xxxx LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: xxxx TO: NOT SPECIFIED
SUBSYSTEM: xxxx ORDER: DATABASE-PAGESET INTERVAL FROM: MM/DD/YY HH:MM:SS.TT
DB2 VERSION: Vx SCOPE: MEMBER TO: MM/DD/YY HH:MM:SS.TT
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ------ ----- ----- ----- ----- ----- ----- ----- ------
DBNAME
TSNAME LOCK TYPE resource-name xxxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
** SUM OF TSNAME ** xxxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
*TOTAL*
DBNAME xxxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxxNote: If
the lock resource type has a value of SKPT (skeleton package table
locking) the Lock Detail report shows compressed parts of the SKPT
resource name as hexadecimal strings in reports and traces. It consists
of the following parts:
- Collection ID, which is compressed.
- Program name, which is compressed.
- Consistency token
Layout of a Locking Detail report for the lock resource type SKPT
Here is an example of the layout of a Locking Detail report for the lock resource type SKPT. LOCATION: xxxx IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: X-Y
GROUP: xxxx LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: xxxx TO: NOT SPECIFIED
SUBSYSTEM: xxxx ORDER: DATABASE-PAGESET INTERVAL FROM: MM/DD/YY HH:MM:SS.TT
DB2 VERSION: Vx SCOPE: MEMBER TO: MM/DD/YY HH:MM:SS.TT
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ------ ----- ----- ----- ----- ----- ----- ----- ------
DBNAME
TSNAME SKPT COLL(HEX)=X'112233445566778899001122334455667788'
PKID(HEX)=X'1122334455667788'
CTKN =0000000000000000
xxxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
** SUM OF TSNAME ** xxxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
*TOTAL*
DBNAME xxxxxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxxField description
Here is a description of all fields except for the report header, which is described in The Locking Header of Reports and Traces.
- LOCK RESOURCE TYPE
- The type of resource on which the lock detail request is made. Valid values are shown in Table 1.
- LOCK RESOURCE NAME
- The name on which the lock detail request is made. Each part of the lock resource name is printed on a separate line. The abbreviations shown in the report are explained, in alphabetical order, in Table 2.
- TOTAL REQ
- The total number of lock requests. The sum is calculated by adding the number of request types like LOCK, UNLOCK, CHANGE, or OTHER request types.
- LOCAL
- The number of lock requests that were not sent to cross-system extended services (XES). The sum is calculated by adding the number of request types like LOCK, UNLOCK, CHANGE, or OTHER request types found in the IRLM FUNCTION CODE if data indicates that the request was not sent to z/OS® XES.
- XES
- The number of lock requests that were sent to cross-system extended services (XES). The sum is calculated by adding the number of request types like LOCK, UNLOCK, CHANGE, or OTHER request types found in the IRLM FUNCTION CODE if data indicates that the request was sent to z/OS XES.
- REQ TYPE
- The lock request types:
- LOCK
- Lock function
- UNLOCK
- Unlock function
- CHNGE
- Change function
- OTHER
- Any other functions
- LOCK STATE
- The lock state can be:
- IS
- Intent share
- IX
- Intent exclusive
- SIX
- Share with intent exclusive
- NSU
- Non shared update
- S
- Share
- X
- Exclusive
- U
- Update
- LOCK DURATION
- The lock duration can be:
- CMT
- Commit
- CMT+1
- Commit + 1
- ALLOC
- Allocation
- MAN
- Manual
- MAN+1
- Manual + 1
- OTHER
- Other
- COND
- The number of lock requests with request type or mode CONDITIONAL.
- AUTREL
- The number of lock requests with request type or mode AUTOMATIC RELEASE.
- TOTAL
- Total lines are printed regardless of the number of different IDs printed before even if the report presents only a single ID.
Locking Detail Report
You can generate a Locking Detail report as follows:
LOCKING
REPORT
SCOPE (MEMBER)
LEVEL (DETAIL)
Locking Detail Report shows a sample Locking Detail report, produced by the following command:
⋮
LOCKING
REPORT
LEVEL (DETAIL)
⋮ LOCATION: OMPD0001 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-1
GROUP: N/P LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U001 TO: NOT SPECIFIED
SUBSYSTEM: DB2U ORDER: DATABASE-PAGESET INTERVAL FROM: 03/04/15 08:54:13.83
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/04/15 09:02:47.51
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
'BLANK'
'BLANK' EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 1 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 2 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 3 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 4 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 5 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 6 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 7 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 8 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 9 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 10 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 11 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 12 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 13 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 14 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 15 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 16 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 17 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 18 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 19 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 20 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 21 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 22 32 0 0 16 16 0 0 0 0 0
... LOCATION: OMPD0001 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-3
GROUP: N/P LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U001 TO: NOT SPECIFIED
SUBSYSTEM: DB2U ORDER: DATABASE-PAGESET INTERVAL FROM: 03/04/15 08:54:13.83
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/04/15 09:02:47.51
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 46 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 47 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 48 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 49 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 50 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 51 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 52 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 53 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 54 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 55 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 56 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 64 0 32 32 0 0 0 0 64 0 0 0
HASH= 57 64 0 0 16 48 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 58 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 59 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 60 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 61 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 62 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 63 32 0 0 16 16 0 0 0 0 0
EXCP UPD RMID= 14 32 0 16 16 0 0 0 0 32 0 0 0
HASH= 64 32 0 0 16 16 0 0 0 0 0
GBP S/S BPID=GBP0 62 0 31 31 0 0 0 0 62 0 0 2
62 0 0 29 2 0 0 0 0 0
GBP S/S BPID=GBP1 68 0 34 34 0 0 0 0 68 0 0 2
68 0 0 32 2 0 0 0 0 0
GBP S/S BPID=GBP16K0 36 0 18 18 0 0 0 0 36 0 0 2
36 0 0 16 2 0 0 0 0 0
GBP S/S BPID=GBP2 68 0 34 34 0 0 0 0 68 0 0 2
68 0 0 32 2 0 0 0 0 0 LOCATION: OMPD0001 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-4
GROUP: N/P LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U001 TO: NOT SPECIFIED
SUBSYSTEM: DB2U ORDER: DATABASE-PAGESET INTERVAL FROM: 03/04/15 08:54:13.83
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/04/15 09:02:47.51
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
GBP S/S BPID=GBP32K 36 0 18 18 0 0 0 0 36 0 0 2
36 0 0 16 2 0 0 0 0 0
GBP S/S BPID=GBP8K0 36 0 18 18 0 0 0 0 36 0 0 2
36 0 0 16 2 0 0 0 0 0
N/P N/P 162916 153K 4705 154K 128 215 130 0 2054 134K 0 322
10147 3928 781 15934 125 651 9068 4375 13075 0
SCA ACCS N/A 56 4 28 28 0 0 0 0 56 0 0 0
52 0 0 0 56 0 0 0 0 0
SKCT PLAN=DCXIP001 4 0 4 0 0 0 0 0 0 0 0 0
4 0 0 4 0 0 0 0 4 0
SKCT PLAN=KO2PLAN 1 1 1 0 0 0 0 0 0 0 0 0
0 0 0 1 0 0 0 0 1 0
SKPT COLL=X'D8C4D4E7D9E3D330D3C3C440404040404040'
PKID=X'C1E7E5C5C9C9D3C3'
CTKN=17C8584801D08F08 3 3 3 0 0 0 0 0 0 3 0 3
0 0 0 3 0 0 0 0 0 0
SKPT COLL=X'E2F7E4D3E2C4F7C4404040404040404040C5'
PKID=X'D4E8E335D4E3D7E4'
CTKN=5359534C564C3031 276 276 276 0 0 0 0 0 0 276 0 276
0 0 0 276 0 0 0 0 0 0
SKPT COLL=X'E2F7E4D3E2C4F7C44040404040404040E335'
PKID=X'F7E2E2C43832D3C3'
CTKN=5359534C564C3031 1586 1586 1586 0 0 0 0 0 0 1586 0 1586
0 0 0 1586 0 0 0 0 0 0
SKPT COLL=X'E2F7E4D3E2C4F7C44040404040404040E335'
PKID=X'F7E2E2C43833D3C3'
CTKN=5359534C564C3031 114823 115K 115K 0 0 0 0 0 0 115K 0 115K
0 0 0 115K 0 0 0 0 0 0
SKPT COLL=X'E2F7E4D3E2C4F7C44040404040404040E335'
PKID=X'F7E2E3343831D3C3'
CTKN=5359534C564C3031 18 18 18 0 0 0 0 0 0 18 0 18
0 0 0 18 0 0 0 0 0 0
SKPT COLL=X'E2F7E4D3E2C4F7C44040404040404040E335'
PKID=X'F7E2E3343832D3C3'
CTKN=5359534C564C3031 10895 10895 10895 0 0 0 0 0 0 10895 0 10895
0 0 0 10895 0 0 0 0 0 0
SKPT COLL=X'E2F7E4D3E2C4F7C44040404040404040E335'
PKID=X'F7E2E3343833D3C3'
CTKN=5359534C564C3031 116 116 116 0 0 0 0 0 0 116 0 116
0 0 0 116 0 0 0 0 0 0
X'FF' DB =10435 1026 0 513 513 0 0 0 0 1026 0 0 0
OB =54996 1026 0 0 0 1026 0 0 0 0 0
X'09' DB =XDELDX31 2 0 1 1 0 0 0 0 2 0 0 0
OB =IXINM200 2 0 0 0 1 0 0 0 0 0
X'09' DB =XDELDX31 2 0 1 1 0 0 0 0 2 0 0 0
OB =IXIPPR02 2 0 0 0 1 0 0 0 0 0
... LOCATION: OMPD0001 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-6
GROUP: N/P LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U001 TO: NOT SPECIFIED
SUBSYSTEM: DB2U ORDER: DATABASE-PAGESET INTERVAL FROM: 03/04/15 08:54:13.83
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/04/15 09:02:47.51
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
X'09' DB =XDELDX31 16 12 8 8 0 0 0 0 16 0 0 8
OB =TSITLD01 4 0 0 0 16 0 0 0 0 0
X'09' DB =XDELDX31 2 0 1 1 0 0 0 0 2 0 0 0
OB =TSSIB008 2 0 0 0 1 0 0 0 0 0
X'09' DB =XDELDX31 4 4 2 2 0 0 0 0 4 0 0 0
OB =232 0 0 0 0 4 0 0 0 0 0
X'2E' DB =512 17 0 17 0 17 0 0 0 0 0 0 0
OB =312 17 0 0 0 0 0 0 0 17 0
X'2F' DB =49876 67167 5570 33584 33583 0 0 0 0 67167 0 0 0
OB =50029 61597 0 0 0 67167 0 0 0 0 0
X'34' DB =58088 523 72 296 227 0 0 0 0 523 0 0 304
OB =57965 451 0 0 523 0 0 0 0 0 0
** SUM OF 'BLANK' 361905 286K 168K 189K 145 215 130 0 73304 262K 0 128K
75740 3928 781 145K 69512 651 9068 4375 13097 0
*TOTAL*
'BLANK' 361905 286K 168K 189K 145 215 130 0 73304 262K 0 128K
75740 3928 781 145K 69512 651 9068 4375 13097 0
DCXID001
327 MASSDEL N/P 6 3 6 0 0 0 0 0 0 6 0 0
3 0 0 6 0 0 0 0 0 0
** SUM OF 327 6 3 6 0 0 0 0 0 0 6 0 0
3 0 0 6 0 0 0 0 0 0
*TOTAL*
DCXID001 6 3 6 0 0 0 0 0 0 6 0 0
3 0 0 6 0 0 0 0 0 0
DSNDB01
DSNLLX01 OPENLOCK N/P 6 6 3 3 0 0 0 0 6 0 0 3
0 0 0 0 3 0 0 0 0 0
PAGEPLCK PART= 1 6 0 3 3 0 0 0 0 0 0 0 0
BPID=BP0 6 0 0 0 3 0 0 0 6 0
PAGEPLCK PART= 1 2 0 1 1 0 0 0 0 0 0 0 0
PAGE=X'00000E88' 2 0 0 0 1 0 0 0 2 0
BPID=BP0
PAGEPLCK PART= 1 2 0 1 1 0 0 0 0 0 0 0 0
PAGE=X'000005A8' 2 0 0 0 1 0 0 0 2 0
BPID=BP0
PAGEPLCK PART= 1 4 0 2 2 0 0 0 0 0 0 0 0
PAGE=X'000005FC' 4 0 0 0 2 0 0 0 4 0
BPID=BP0
... LOCATION: OMPD0001 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-9
GROUP: N/P LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U001 TO: NOT SPECIFIED
SUBSYSTEM: DB2U ORDER: DATABASE-PAGESET INTERVAL FROM: 03/04/15 08:54:13.83
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/04/15 09:02:47.51
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
PAGEPLCK PART= 1 2 0 1 1 0 0 0 0 0 0 0 0
PAGE=X'00005F83' 2 0 0 0 1 0 0 0 2 0
BPID=BP0
PAGEPLCK PART= 1 2 0 1 1 0 0 0 0 0 0 0 0
PAGE=X'00005F88' 2 0 0 0 1 0 0 0 2 0
BPID=BP0
PAGEPLCK PART= 1 6 0 3 3 0 0 0 0 0 0 0 0
PAGE=X'00005F91' 6 0 0 0 3 0 0 0 6 0
BPID=BP0
PAGEPLCK PART= 1 2 0 1 1 0 0 0 0 0 0 0 0
PAGE=X'00005F92' 2 0 0 0 1 0 0 0 2 0
BPID=BP0
PAGEPLCK PART= 1 2 0 1 1 0 0 0 0 0 0 0 0
PAGE=X'00005F94' 2 0 0 0 1 0 0 0 2 0
BPID=BP0
** SUM OF DSNLLX02 66 6 33 33 0 0 0 0 6 0 0 3
60 0 0 5 28 0 0 0 60 0
SYSLGRNX DATAPAGE PAGE=X'000006B0' 1 0 1 0 0 0 0 0 0 1 0 1
1 0 0 0 0 1 0 0 0 1
DATAPAGE PAGE=X'000008B3' 1 0 1 0 0 0 0 0 0 1 0 1
1 0 0 0 0 1 0 0 0 1
DATAPAGE PAGE=X'0000095A' 1 0 1 0 0 0 0 0 0 1 0 1
1 0 0 0 0 1 0 0 0 1
DATAPAGE PAGE=X'00000957' 2 0 2 0 0 0 0 0 0 2 0 2
2 0 0 0 0 2 0 0 0 2
DATAPAGE PAGE=X'00000958' 9 0 9 0 0 0 0 0 0 9 0 9
9 0 0 0 0 9 0 0 0 9
DATAPAGE PAGE=X'00000959' 2 0 2 0 0 0 0 0 0 2 0 2
2 0 0 0 0 2 0 0 0 2
DATAPAGE PAGE=X'00001DD6' 3 0 3 0 0 0 0 0 0 3 0 3
3 0 0 0 0 3 0 0 0 3
DATAPAGE PAGE=X'00001DD9' 3 0 3 0 0 0 0 0 0 3 0 3
3 0 0 0 0 3 0 0 0 3
DATAPAGE PAGE=X'00007F6D' 24 0 14 0 0 0 0 0 10 14 0 14
24 10 0 0 10 14 0 0 0 4
DATAPAGE PAGE=X'oo007F6E' 2 0 2 0 0 0 0 0 0 2 0 2
2 0 0 0 0 2 0 0 0 2
DATAPAGE PAGE=X'00007F6F' 1 0 1 0 0 0 0 0 0 1 0 1
1 0 0 0 0 1 0 0 0 1
DATAPAGE PAGE=X'00007F69' 1 0 1 0 0 0 0 0 0 1 0 1
1 0 0 0 0 1 0 0 0 1
DATAPAGE PAGE=X'00007F70' 16 0 11 0 0 0 0 0 5 11 0 11
16 5 0 0 5 11 0 0 0 6 LOCATION: OMPD0001 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-10
GROUP: N/P LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U001 TO: NOT SPECIFIED
SUBSYSTEM: DB2U ORDER: DATABASE-PAGESET INTERVAL FROM: 03/04/15 08:54:13.83
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/04/15 09:02:47.51
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
DATAPAGE PAGE=X'00007F71' 21 0 14 0 0 0 0 0 7 14 0 14
21 7 0 0 9 12 0 0 0 5
DATAPAGE PAGE=X'00007F72' 40 0 30 0 0 0 0 0 10 30 0 30
40 10 0 0 30 10 0 0 0 0
OPENLOCK N/P 6 6 3 3 0 0 0 0 6 0 0 3
0 0 0 0 3 0 0 0 0 0
PAGEPLCK PART= 1 6 0 3 3 0 0 0 0 0 0 0 0
BPID=BP0 6 0 0 0 3 0 0 0 6 0
PAGESET N/P 59 0 59 0 0 59 0 0 0 59 0 0
59 0 0 0 0 0 0 0 0 0
** SUM OF SYSLGRNX 198 6 160 6 0 59 0 0 38 154 0 98
192 32 0 0 60 73 0 0 6 41
*TOTAL*
DSNDB01 334 18 228 74 0 59 0 0 50 154 0 104
316 32 0 5 123 73 0 0 130 41
DSNDB06
DSNACH01 DRAIN CS N/P 2 0 1 1 0 0 0 0 2 0 0 1
2 0 0 1 0 0 0 0 0 0
OPENLOCK N/P 2 2 1 1 0 0 0 0 2 0 0 0
0 0 0 0 1 0 0 0 0 0
** SUM OF DSNACH01 4 2 2 2 0 0 0 0 4 0 0 1
2 0 0 1 1 0 0 0 0 0
SYSDBASE DATAPAGE PAGE=X'00000027' 12 12 12 0 0 0 0 0 12 0 0 9
0 0 0 12 0 0 0 0 0 0
DATAPAGE PAGE=X'00000028' 6 6 6 0 0 0 0 0 6 0 0 0
0 0 0 6 0 0 0 0 0 0
DATAPAGE PAGE=X'0000016E' 132 132 66 66 0 0 0 0 66 0 0 0
0 0 0 132 0 0 66 0 0 0
DATAPAGE PAGE=X'0000016F' 24 24 12 12 0 0 0 0 12 0 0 0
0 0 0 24 0 0 12 0 0 0
DATAPAGE PAGE=X'00000170' 1656 1656 864 792 0 0 0 0 864 0 0 72
0 0 0 1656 0 0 792 0 0 0
DATAPAGE PAGE=X'00000174' 720 720 400 320 0 0 0 0 400 0 0 0
0 0 0 720 0 0 320 0 0 0
DATAPAGE PAGE=X'00001337' 97 97 97 0 0 0 0 0 97 0 0 0
0 0 0 97 0 0 0 0 0 0
DATAPAGE PAGE=X'000014A7' 4 4 4 0 0 0 0 0 4 0 0 3
0 0 0 4 0 0 0 0 0 0
DATAPAGE PAGE=X'0000149A' 4 4 4 0 0 0 0 0 4 0 0 3
0 0 0 4 0 0 0 0 0 0
... LOCATION: OMPD0001 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 1-5966
GROUP: N/P LOCKING REPORT - DETAIL REQUESTED FROM: NOT SPECIFIED
MEMBER: DB2U001 TO: NOT SPECIFIED
SUBSYSTEM: DB2U ORDER: DATABASE-PAGESET INTERVAL FROM: 03/04/15 08:54:13.83
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/04/15 09:02:47.51
--REQ TYPE-- -----LOCK STATE-------- --LOCK DURATION--
DATABASE --- L O C K R E S O U R C E --- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
PAGESET TYPE NAME REQ XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
------------------ --------- ----------------------- -------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
DATAPAGE PAGE=X'000039D5' 12 12 12 0 0 0 0 0 12 0 0 9
0 0 0 12 0 0 0 0 0 0
DATAPAGE PAGE=X'000039EE' 12 12 12 0 0 0 0 0 12 0 0 9
0 0 0 12 0 0 0 0 0 0
DATAPAGE PAGE=X'000039EF' 52 52 52 0 0 0 0 0 52 0 0 39
0 0 0 52 0 0 0 0 0 0
DATAPAGE PAGE=X'000039E4' 52 52 52 0 0 0 0 0 52 0 0 39
0 0 0 52 0 0 0 0 0 0
DATAPAGE PAGE=X'000039F0' 32 32 32 0 0 0 0 0 32 0 0 24
0 0 0 32 0 0 0 0 0 0
DATAPAGE PAGE=X'00003968' 5 5 5 0 0 0 0 0 5 0 0 4
0 0 0 5 0 0 0 0 0 0
DATAPAGE PAGE=X'00003971' 410 410 410 0 0 0 0 0 410 0 0 328
0 0 0 410 0 0 0 0 0 0
DATAPAGE PAGE=X'00003999' 4 4 4 0 0 0 0 0 4 0 0 3
0 0 0 4 0 0 0 0 0 0
PAGESET N/P 126 11 126 0 126 0 0 0 0 126 0 0
115 0 0 0 0 0 0 0 0 0
** SUM OF 9 2038 1923 1901 137 126 0 0 0 1775 126 0 601
115 0 0 1912 0 0 137 0 0 0
*TOTAL*
6 2602 2095 2417 185 368 0 0 0 1918 451 42 723
507 0 0 2180 27 0 137 0 54 0
*GRAND TOTAL* 2160727 1050K 1576K 568K 244K 70460 130 0 537K 891K 37113 566K
1111K 15686 781 983K 395K 5621 62188 5017 629K 40093
LOCKING REPORT COMPLETE