Notes on option specifications

A specific type of statistical information can be extracted by combining the -k option with other options. The table below shows the relationships between the -k option and the other options.

Table 14-3 Relationships between the -k option and other options

-k option (value)	Other options
-k option (value)	-t start time and/or end time	-u UAP name(s)	-x host name(s)	-s server name(s)
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
all (all the above)	Y	Y	Y	Y

Y: Can be specified (when specified, the corresponding information can be extracted).

--: Ignored if specified (the corresponding information cannot be extracted).

When -k idx is specified, the -o option is ignored, if specified.
If the -d option is specified when -k idx or -k all is specified, the target information can be extracted.
If sop, dop, or pcd is specified in the -k option, the -o option must also be specified.

The following table shows the files that can be input and the statistical information that can be analyzed when the -i or -d option is specified:

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
-i	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

When -k uap is specified, the statistical information acquisition units depend on the UAP execution environment. The following table shows the relationship between client environment definition (PDSTJTRNOUT) during UAP execution and statistical information acquisition units:

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

Contents of PDSTJTRNOUT	Type of UAP
Contents of PDSTJTRNOUT	OLTP environment	Other environment
YES	By transaction	By transaction
NO	By UAP execution	By UAP execution
Omitted	By transaction	By UAP execution

14.2.3 Notes on option specifications