Table 14-2 Relationships between the -k option and other options
-k option (value) | Other options | ||||
---|---|---|---|---|---|
-t start time and/or end time | -u UAP name(s) | -x host name(s) | -s server name(s) | -f foreign-server-name | |
sys (system activity statistical information) | Y | ![]() | Y | ![]() | ![]() |
svr (system activity statistical information by server) | Y | ![]() | Y | Y | ![]() |
uap (UAP statistical information) | Y | Y | Y | ![]() | ![]() |
sql (SQL statistical information) | Y | Y | Y | ![]() | ![]() |
buf (global buffer pool statistical information) | Y | ![]() | Y | Y | ![]() |
fil (statistical information on HiRDB files for database manipulation) | Y | ![]() | Y | Y | ![]() |
dfw (deferred write processing statistical information) | Y | ![]() | Y | Y | ![]() |
idx (index statistical information) | Y | ![]() | ![]() | Y | ![]() |
sop (SQL static optimization information) | Y | Y | Y | ![]() | ![]() |
dop (SQL dynamic optimization information) | Y | Y | Y | ![]() | ![]() |
pcd (SQL object execution information) | Y | Y | Y | ![]() | ![]() |
obj (SQL object transfer statistical information) | Y | Y | Y | ![]() | ![]() |
sqh (SQL statement statistical information) | Y | Y | Y | Y | ![]() |
cnc (CONNECT/DISCONNECT statistical information) | Y | Y | Y | Y | ![]() |
fsv (foreign server operation statistical information) | Y | Y | Y | Y | Y |
hba (foreign server utilization statistical information) | Y | Y | Y | Y | Y |
all (all the above) | Y | Y | Y | Y | ![]() |
Option | File that can be input | Statistical information that can be analyzed |
---|---|---|
-i | Unload log file | Information about splitting index statistical information Statistical information about CONNECT/DISCONNECT |
Unload statistics log file | All statistical information other than the above | |
-d | System log file | Information about splitting index statistical information Statistical information about CONNECT/DISCONNECT |
Contents of PDSTJTRNOUT | Type of UAP | |
---|---|---|
OLTP environment | Other environment | |
YES | By transaction | By transaction |
NO | By UAP execution | By UAP execution |
Omitted | By transaction | By UAP execution |