pdls [-d stj] (Display whether or not statistical data output type by unit and server is specified)
Function
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.
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
- Return code 0 for the pdls -d stj command indicates normal termination, and return code 8 indicates abnormal termination.
- 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.
- For a HiRDB/Single Server, this command does not display statistical information about SQL object transfer, external server activities, or external server utilization status.
- 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