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

Function

Displays the following types of information:

Format

pdls -d stj [-s server-identifier]

Option

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.

Note

  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, this command does not display statistical information about SQL object transfer, external server activities, or external server utilization status.
  4. The headers for fsv and hba are displayed even when HiRDB External Data Access has not been installed.

Output format

HOSTNAME : aa...a(bbccdd)
UNITID      sys
eeee         h
INTERVAL : ff...f
 SVID       sys uap sql buf fil dfw idx sop dop pcd sqh obj fsv hba
 gg...g       i    j   k   l   m   n   o   p   q   r   s   t    u   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-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.
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
u
Statistical information about external server activities
v
Statistical information about external server utilization status