pdls [-d lck] (Display server lock control status)
Function
Displays server lock status.
Format
pdls -d lck [{-a [-s server-name] | -p}]
Options
- {-a [-s server-name] | -p}
Specifies whether both occupancy and wait information or the utilization factor of the tables for managing locked resources is to be displayed. When this option is omitted, only the wait information is displayed. If the -a and -p options are both specified, the -p option is effective.
- -a
- Specifies that both occupancy and wait information are to be displayed. When this option is omitted, only the wait information is displayed.
- -s server-name
<identifier> ((1-8)) - Specifies the name of the server whose wait information only is to be displayed. When this option is omitted, information about all servers is displayed.
- -p
- Specifies that the utilization factor of the tables for managing locked resources is to be displayed.
Notes
- Return code 0 for the pdls -d lck command indicates normal termination, and return code 8 indicates abnormal termination.
Output format
Options omitted or -a and -s options specified:
HOSTNAME : aa...a(bbccdd)
SVID PID TID KIND RESOURCE
WAIT MODE TRNBID ACTID LOCK-STATE DPRIO
ee...e ff...f gg...g hhhh ii...i
jj...j kk ll...l mm...m-nn...n-oo...o p qqq ...1
: |
- Explanation
- 1 is displayed as many times as there are occupancy and wait information items.
- aa...a
- Host name (up to 32 characters).
- bbccdd
- Time of pdls command execution (hour:minute:second).
- ee...e
- Server name (up to 8 characters).
- ff...f
- Process ID (32-bit mode: 5 decimal digits; 64-bit mode: 10 decimal digits)
- gg...g
- Thread ID (5 decimal digits).
- hhhh
- Resource type (4 hexadecimal digits).
- ii...i
- Resource name (28 hexadecimal digits).
- jj...j
- Wait time (5 decimal digits; in seconds).
- ***** is displayed for the occupancy information.
- kk
- Lock mode (2 characters).
- ll...l
- Transaction identifier (16 characters).
- If Y is displayed for p (lock hold status of UNTIL DISCONNECT specification), this transaction branch may already have been terminated. Therefore, the pdls -d trn command may not be able to display the status, depending on the timing.
- mmmm-nnnn-oo...o
- User identification number (up to 16 decimal digits).
- p
- Lock hold status of UNTIL DISCONNECT specification:
- Y
- Lock is held
- N
- Lock is not held
- qqq
- Deadlock priority value (up to 3 decimal digits).
-p option specified:
HOSTNAME: aa...a(bbccdd)
SVID TABLE-KIND TOTAL KIND RATE
ee...e RESOURCE ff...f gg...g hh% 1
: : : : :
- Explanation
1 is displayed as many times as there are servers.
- aa...a
- Host name (up to 32 characters).
- bbccdd
- Time of pdls command execution (hour:minute:second).
- ee...e
- Server name (up to 8 characters).
- ff...f
- Maximum number of tables for managing locked resources that can be used (32-bit mode: 8 decimal digits; 64-bit mode: 10 decimal digits).
- gg...g
- Number of tables for managing locked resources currently in use (32-bit mode: 8 decimal digits; 64-bit mode: 10 decimal digits).
- hh
- Utilization factor of the tables for managing locked resources (%).