2.73 pdls [-d stj] (Display whether statistical data output type by unit and server is specified)

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

(1) Function

Displays the following types of information:

(2) Format

pdls -d stj [-s server-name]
[{-x host-name[,host-name]...|-u unit-identifier[,unit-identifier]...}]

(3) Option

(a) -s server-name <identifier> ((1-8))

Specifies the name of the server that displays whether or not types of statistical information output are specified. The default is to display all servers.

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

(c) -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 stj command indicates normal termination, and return code 8 indicates abnormal termination.
  2. If a file error occurs during output of statistical information, the display of whether the output of statistical information is specified by the pdls -d stj command results in a no statistical information output display.
  3. For a HiRDB single server configuration, this command does not display statistical information about SQL object transfer.
  4. For details about the statistical information type for displaying thread-to-thread lock-release wait time, see (4) Options under pdstbegin (Start output of statistical information).

(5) Output format

HOSTNAME : aa...a(bbccdd)
UNITID      sys
eeee         h
INTERVAL : ff...f     DIO-INTERVAL : uu...u
 SVID       sys uap sql buf fil dfw idx sop dop pcd sqh obj dio
 gg...g        i    j   k   l    m   n   o   p   q   r    s   t   v
    :                       :

Explanation
aa..a
Host name (up to 32 characters)
bbccdd
Time of execution of pdls -d stj command (hour:minute:second)
eeee
Unit identifier (4 characters)
ff..ff
Displays the time interval at which system activity statistical information is output, in minutes. If the output of system activity statistical information is not specified, a value of 0 is displayed (up to 4 decimal digits).
gg..g
Server name (up to 8 characters)
If no servers are found in the unit, this option displays ********.
For items h to t and v as follows, if output of the applicable statistical information is specified, the system displays * ; otherwise, it displays a blank. For the alternate BES unit when the standby-less system switchover (1:1) facility is used, the system displays - instead of h. If thread-to-thread lock-release wait time is collected, w is displayed for i. If thread-to-thread lock-release wait time in the statistical information on UAPs and global buffer pools is also collected, w is displayed for i and an asterisk (*) is displayed for j and l.
When statistical information related to database I/O operations is acquired, the information that is displayed for v depends on the pdstbegin operand specified in the system common definition or the -D option specified in the pdstbegin command. The following table shows the information that is displayed for v:
everyioeveryfileInformation that is displayed
NN*
NYF
YNI
YYA
Legend:
Y: Specified
N: Omitted

h
System activity statistical information by unit
i
System activity statistical information by server
j
UAP statistical information
k
SQL statistical information
l
Global buffer pool statistical information
m
Statistical information on HiRDB files for database manipulation
n
Deferred write processing statistical information
o
Index statistical information
p
SQL static optimization information
q
SQL dynamic optimization information
r
SQL object execution information
s
SQL statement statistical information
t
Statistics on SQL object transmission
uu...u:
Displays (in seconds) the interval at which statistial information related to database I/O operations is output (up to 4 decimal digits). If output of statistical information related to database I/O operations was not specified, 0 is displayed.
v:
Statistical information related to database I/O operations