Displays the following types of information:

• Whether or not types of statistical information output are specified by the pdstbegin command for each unit or server or by the pdstbegin command for the system common definitions.
• Whether or not output of statistical information regarding system operation is specified by the pd_statistics operand for the system common definitions.

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

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

 
 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:

everyio	everyfile	Information that is displayed
N	N	*
N	Y	F
Y	N	I
Y	Y	A

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