2.65 pdls [-d lck] (Display server lock control status)

Organization of this section
(1) Function
(2) Format
(3) Options
(4) Notes
(5) Output format

(1) Function

The pdls [-d lck] command displays server lock status (lock and wait information), usage rate of the table for managing locked resources, or statistical information for lock pool partitions.

(2) Format

pdls -d lck {[-a][-s server-name]|[-p[-e]]|[-T[-R]]}
[{-x host-name[,host-name]...|-u unit-identifier[,unit-identifier]...}]

(3) Options

The options specify whether to display server lock status (lock and wait information), usage rate of the table for managing locked resources, or statistical information for lock pool partitions. If no options are specified, only wait information is displayed.

(a) -a

Specifies that both occupancy and wait information are to be displayed.

(b) -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.

(c) -p

Specifies that the utilization factor of the tables for managing locked resources is to be displayed for each server.

(d) -e

Specifies that detailed information about the pool partitions for locking is to be displayed for each server.

(e) -T

Specifies that statistical information for lock pool partitions is to be displayed. You can use the displayed information for tuning the number of lock pool partitions. For details about how to tune lock pool partitions, see Partitioning the lock pool in the HiRDB Version 9 System Operation Guide.

Of the information that is output when the -T option is specified, the information listed below will be reset to 0 if the maximum number of characters that can be displayed is exceeded (you can prevent the information from being reset to 0 by also specifying the -R option):

(f) -R

Specifies that the statistical information generated since the last time the command was executed up to the point of the current command execution is to be collected. When you specify this option, do not execute the command more than once concurrently because the command collects differential statistical information that was generated since the last time statistical information was collected. If this is the first time the command has been executed since HiRDB started, it collects statistical information generated since HiRDB started up to the point of the command's execution.

If this option is omitted, the command collects statistical information since HiRDB started up to the point of the command's execution.

(g) -x host-name[,host-name]...

Specifies the names of hosts whose information is to be displayed.

If this option is specified together with the -s option, the -s option is effective and the -x option is ignored. If you specify multiple host names, there must be no spaces before or after a delimiter comma.

(h) -u unit-identifier[,unit-identifier]...

Specifies units whose information is to be displayed.

If this option is specified together with the -s option, the -s option is effective and the -u option is ignored. If you specify multiple unit names, there must be no spaces before or after a delimiter comma.

(4) Notes

  1. Return code 0 for the pdls -d lck command indicates normal termination, and return code 8 indicates abnormal termination.

(5) Output format

(a) 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

The items indicated by 1 are displayed as many times as there are occupancy and wait information items.

The items are separated by at least one single-byte space.

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 (up to five right-aligned decimal digits if the value is 99999 or less, and up to 10 left-aligned decimal digits if the value is 100000 or more)
If the value is 100000 or more, the items that follow TID (thread ID) are shifted to the right.
gg...g
Thread ID (5 decimal digits).
hhhh
Resource type (4 hexadecimal digits).
ii...i
Resource name (28 hexadecimal digits).
jj...j
Wait time (up to five right-aligned decimal digits if the value is 99999 or less, and up to 10 left-aligned decimal digits if the value is 100000 or more)
If the value is 100000 or more, the items that follow MODE (lock mode) are shifted to the right.
***** 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 22 characters)
If the user identification number consists of 19 characters or more, the items that follow LOCK-STATE (lock hold status of UNTIL DISCONNECT specification) are shifted to the right.
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).
If this is lock information and wait information acquired within HiRDB, -1 might be output.
Output example
When a process ID of 100000 or more is subject to display:

HOSTNAME : HOST0001(145717)
SVID       PID     TID  KIND  RESOURCE                       WAIT  MODE
TRNBID              ACTID               LOCK-STATE  DPRIO
SERVER01   38095   1    0001  0300000000000000000000000000​  *****  SR
PRDBUNT000010003​    16-1-2              N              64  ... Process ID is 99999 or less
SERVER01   108221   1    0002  0300020000000000000000000000​  *****  SR
 PRDBUNT000010003​    16-1-2              N              64 ... Process ID is 100000 or more
SERVER01    8101   1    0007  000300000​e450000030002000000​  *****  PR  
PRDBUNT000010003​    16-1-2              N              64  ... Process ID is 99999 or less

(b) When the -p option is specified and the -e option is omitted

HOSTNAME: aa...a(bbccdd)
SVID       TABLE-KIND  TOTAL  KIND  RATE
ee...e       RESOURCE  ff...f gg...g  hh%   ...1
:           :          :      :       :

Explanation

The items indicated by 1 are displayed as many times as there are servers.

The items indicated by 1 are separated by at least one single-byte space.

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 locked resources that can be managed (32-bit mode: 8 decimal digits; 64-bit mode: 10 decimal digits).
gg...g
Number of locked resources currently managed (32-bit mode: 8 decimal digits; 64-bit mode: 10 decimal digits).
hh
Utilization factor of the tables for managing locked resources (%).
(c) When the -p and -e options are specified

HOSTNAME : aa...a(bbccdd)
SVID : ee...e   ...1
TABLE-NAME       TABLE-KIND   TOTAL   USED   RATE-C RATE-T  ...1
ff...f           gg...g       hh...h  ii...i   jjj%   kkk%  ...1, 2
  :                 :            :       :      :      :
SVID : ee...ee   ...1
TABLE-NAME       TABLE-KIND   TOTAL   USED   RATE-C RATE-T  ...1
ff...f           gg...g       hh...h  ii...i   jjj%   kkk%  ...1, 2
  :                 :            :       :      :      :

Explanation

This information is displayed for each unit on the host that is displayed in HOSTNAME. If the unit has no HiRDB server, only HOSTNAME is displayed. For a HiRDB single server configuration, a unit that has no HiRDB server means a utility special unit. For a HiRDB parallel server configuration, a unit that has no HiRDB server means a unit on which only the system manager is installed or a unit that uses the standby-less system switchover (effects distributed) facility and on which no back-end server is running.

The items indicated by 1 are displayed for each server and items indicated by 2 are displayed for each pool partition for locking.

The items indicated by 2 are separated by at least one single-byte space.

aa...a:
Host name (up to 32 characters)
bbccdd:
Time the pdls command was executed (hour, minute, second)
ee...e:
Server name (up to 8 characters)
ff...f:
Name of pool partition for locking that was generated by HiRDB (up to 16 characters)
gg...g:
Table type (up to 8 characters):
RESOURCE: Table for managing locked resources
hh...h:
Maximum number of locked resources that can be managed (unsigned integer of up to 9 digits)
ii...i:
Number of locked resources currently managed (unsigned integer of up to 9 digits)
jjj:
Current usage rate (value is rounded off) (unsigned integer of up to 3 digits)
kkk:
Maximum usage rate from when HiRDB started until the current time (value is rounded off) (unsigned integer of up to 3 digits)
(d) When the -T and -R options are specified

HOSTNAME : aa...a(bbccdd)
SVID : nn...n   ...1
RANGE : eeee/ff/gg hh:ii:jj - kkkk/ll/mm bb:cc:dd...1
TABLE-NAME TABLE-KIND RATE-T L-CNT  T-CNT  W-RATE Q-LEN W-TIME W-TIME-T ...1
oo...o     pp...p     qqq%   rr...r ss...s ttt.t%  uuuu vvvv.v   wwww.w ...1,2
   :          :        :        :      :      :      :    :        :
SVID : nn...n   ...1
RANGE : eeee/ff/gg hh:ii:jj - kkkk/ll/mm bb:cc:dd...1
TABLE-NAME TABLE-KIND RATE-T L-CNT  T-CNT  W-RATE Q-LEN W-TIME W-TIME-T ...1
oo...o     pp...p     qqq%   rr...r ss...s ttt.t%  uuuu vvvv.v   wwww.w ...1,2
   :          :        :        :      :      :      :    :        :

Explanation

This information is displayed for each unit on the host that is displayed in HOSTNAME. If the unit has no HiRDB server, only HOSTNAME is displayed. For a HiRDB single server configuration, a unit that has no HiRDB server means a utility special unit. For a HiRDB parallel server configuration, a unit that has no HiRDB server means a unit on which only the system manager is installed or a unit that uses the standby-less system switchover (effects distributed) facility and on which no back-end server is running.

The items indicated by 1 are displayed for each server and items indicated by 2 are displayed for each pool partition for locking.

The items indicated by 2 are separated by at least one single-byte space.

aa...a:
Host name (up to 32 characters)
bbccdd:
Time the pdls command was executed (hour, minute, second)
eeee/ff/gg hh:ii:jj:
Last date and time the pdls -d lck -T -R command was executed (year, month, date, hour, minute, second)
If this is the first execution of the command since HiRDB started, the date and time HiRDB started are displayed.
kkkk/ll/mm bb:cc:dd:
Date and time the pdls -d lck -T -R command was executed (year, month, date, hour, minute, second)
nn...n:
Server name (up to 8 characters)
oo...o:
Name of pool partition for locking that was generated by HiRDB (up to 16 characters)
pp...p:
Table type (up to 8 characters):
RESOURCE: Table for managing locked resources
qqq:
Maximum usage rate of locked resources (value is rounded off)
rr...r:
Number of lock requests (unsigned integer of up to 16 digits)
ss...s:
Number of thread-to-thread lock requests in pool partitions for locking (unsigned integer of up to 16 digits)
ttt.t:
Ratio of the number of times a thread-to-thread lock-release wait occurred to the number of thread-to-thread lock requests in pool partitions for locking (values are rounded off to one digit following the decimal point)
uuuu:
Average number of thread-to-thread lock-release waits in pool partitions for locking
For each pool partition for locking, this is the total number of thread-to-thread lock-release waits in the system activity-related statistical information (values are rounded off).
vvvv.v:
Average thread-to-thread lock-release wait time (milliseconds)#1, #2
wwww.w:
Maximum thread-to-thread lock-release wait time (milliseconds)#1, #2
#1
The displayed information depends on whether the thread-to-thread lock-release wait time is collected as statistical information.
When this statistical information is collected:
  • If the average thread-to-thread lock-release wait time is 10 seconds or longer, 9999.9 is displayed for vvvv.v.
  • If the maximum thread-to-thread lock-release wait time is 10 seconds or longer, 9999.9 is displayed for wwww.w.
  • If the average and maximum values are both less than 10 seconds, the acquired time is displayed.
When this statistical information is not collected:
****.* is displayed.
#2
Because the precision of the displayed value depends on the OS and the hardware being used, the value that is displayed might be smaller than the actual value.
Note
If the -T and -R options are specified after the pdstbegin command with the -w option specified has been executed, values smaller than the actual values are displayed for the following items:
  • Average thread-to-thread lock-release wait time
  • Maximum thread-to-thread lock-release wait time
Therefore, if you collect statistical information on thread-to-thread lock-release wait time, first execute the pdstbegin command with the -w option specified, and then execute the pdls -d lck command with the -T and -R options specified.
(e) When the -T option is specified and the -R option is omitted

HOSTNAME : aa...a(bbccdd)
SVID : nn...n   ...1
TABLE-NAME  TABLE-KIND  RATE-T   L-CNT   T-CNT W-RATE Q-LEN ...1
oo...o      pp...p        qqq%  rr...r  ss...s ttt.t%  uuuu ...1,2
   :           :           :      :        :     :       :
SVID : nn...n   ...1
TABLE-NAME  TABLE-KIND  RATE-T   L-CNT   T-CNT W-RATE Q-LEN ...1
oo...o      pp...p        qqq%  rr...r  ss...s ttt.t%  uuuu ...1,2
   :           :           :      :        :     :       :

Explanation

This information is displayed for each unit on the host that is displayed in HOSTNAME. If the unit has no HiRDB server, only HOSTNAME is displayed. For a HiRDB single server configuration, a unit that has no HiRDB server means a utility special unit. For a HiRDB parallel server configuration, a unit that has no HiRDB server means a unit on which only the system manager is installed or a unit that uses the standby-less system switchover (effects distributed) facility and on which no back-end server is running.

The items indicated by 1 are displayed for each server and items indicated by 2 are displayed for each pool partition for locking.

The items indicated by 2 are separated by at least one single-byte space.

aa...a:
Host name (up to 32 characters)
bbccdd:
Time the pdls command was executed (hour, minute, second)
nn...n:
Server name (up to 8 characters)
oo...o:
Name of pool partition for locking that was generated by HiRDB (up to 16 characters)
pp...p:
Table type (up to 8 characters):
RESOURCE: Table for managing locked resources
qqq:
Maximum usage rate of locked resources (value is rounded off)
rr...r:
Number of lock requests (unsigned integer of up to 16 digits)
ss...s:
Number of thread-to-thread lock requests in pool partitions for locking (unsigned integer of up to 16 digits)
ttt.t:
Ratio of the number of times a thread-to-thread lock-release wait occurred to the number of thread-to-thread lock requests in pool partitions for locking (values are rounded off to one digit following the decimal point)
uuuu:
Average number of thread-to-thread lock-release waits in pool partitions for locking
For each pool partition for locking, this is the total number of thread-to-thread lock-release waits in the system activity-related statistical information (value is rounded off).