The following example commands show how to export and display lock statistics:
$ ADVISE PERFORMANCE EXPORT /NODE=ULTRA/OUTPUT=EXP.LOCK/CLASS=(NODEFAULT, LOCK) _$ /BEGINNING=26-JAN-1997:14:00:00.00/ENDING=26-JAN-1997:14:02:00.00 $ TYPE EXP.LOCK "ULTRA ", "VERS", "Vx.x", "REPORT=LOG_FILE", "Vx.x", "CPD" "26-JAN-1997 14:00:00.00", "26-JAN-1997 14:02:00.00", "ULTRA ", "LOCK", 23.2, 12.6, 0.0, 19.8, 4.6, 0.0, 24.0, 12.8, 0.0, 0.1, 0.0, 0.1, 9.5, 0.0, 0.0, 0.0, 44.0, 0.0, 0.0, 0.0, 10308.0, 4835.0 $
|
Example |
Data item |
Description |
Position |
Length |
|---|---|---|---|---|
|
23.2 |
enq_local |
enq ops/sec by lcl node for lcl lcks |
91 |
7 |
|
12.6 |
enq_in |
enq ops/sec req by rem node for lcl lcks |
100 |
7 |
|
0.0 |
enq_out |
enq ops/sec req by lcl node for rem lcks |
109 |
7 |
|
19.8 |
cvtenq_local |
conv ops/sec by lcl node for lcl lcks |
118 |
7 |
|
4.6 |
cvtenq_in |
conv ops/sec by rem nodes for lcl lcks |
127 |
7 |
|
0.0 |
cvtenq_out |
conv ops/sec by lcl node for remote lcks |
136 |
7 |
|
24.0 |
deq_local |
deq ops/sec by lcl node for lcl lcks |
145 |
7 |
|
12.8 |
deq_in |
deq ops/sec by remote nodes for lcl lcks |
154 |
7 |
|
0.0 |
deq_out |
deq ops/sec by lcl node for remote lcks |
163 |
7 |
|
0.1 |
blkast_local |
blking ast/sec by lcl node for lcl lcks |
172 |
7 |
|
0.0 |
blkast_in |
blking ast/sec by rem nodes for lcl lcks |
181 |
7 |
|
0.1 |
blkast_out |
blking ast/sec by lcl node for rem lcks |
190 |
7 |
|
9.5 |
dirfunc_in |
lcks/sec for directory ops by remote node for lcl directories |
199 |
7 |
|
0.0 |
dirfunc_out |
lcks/sec for directory ops by lcl node for lcl directories |
208 |
7 |
|
0.0 |
dlckmsg_in |
deadlock msg/sec received from rem nodes |
217 |
7 |
|
0.0 |
dlckmsg_out |
deadlock msg/sec sent to remote nodes |
226 |
7 |
|
44.0 |
enq_wait |
# of times lock unavailable and process waited |
235 |
7 |
|
0.0 |
enq_notqd |
# of times lock unavailable and process did not wait |
244 |
7 |
|
0.0 |
dlck_search |
# of times a deadlock search initiated by lcl system |
253 |
7 |
|
0.0 |
dlck_find |
# of times a deadlock condition was found by lcl system |
262 |
7 |
|
10308.0 |
tot_locks |
total # of lcks outstanding |
271 |
7 |
|
4835.0 |
tot_resources |
total # of resources that can be locked |
280 |
7 |
|
Copyright © 2008 CA.
All rights reserved.
|
|