When statistical information is output to a DAT-format file, one file is created for each type of statistical information. The file is created under a user-specified directory. Table 14-4 lists the names of DAT-format files.

Table 14-4 Names of DAT-format files

Edited information	Output unit	File name
System activity statistical information	Activity information in the log for one system	sys_DAT
UAP statistical information	Execution of one UAP or one service	uap_DAT
SQL statistical information	Execution of one SQL	sql_DAT
Global buffer pool statistical information	Each synchronization point	buf_DAT
Statistical information about HiRDB files for database manipulation	Each synchronization point	fil_DAT
Deferred write processing statistical information	Each activation of deferred write daemon	dfw_DAT
Static optimization information	Preprocessing of one SQL	sop_DAT
Dynamic optimization information	Each server within an SQL	dop_DAT
SQL object execution information	Each parallel SQL	pcd_DAT
SQL object transfer statistical information	Each parallel SQL	obj_DAT
SQL statement statistical information	Execution of one SQL	sqh_DAT
CONNECT/DISCONNECT statistical information	Each CONNECT/DISCONNECT	cnc_DAT
Foreign server operation statistical information	Each transaction	fsv_DAT
Foreign server utilization statistical information	Each thread execution	hba_DAT

Notes

1. Each file has a predefined name. If the same file name is found in the user-specified directory, the existing file may be overwritten. To avoid this, the existing file should be renamed or a different directory should be specified.
2. A DAT-format file cannot store more than 2 gigabytes of data. When you are using a large number of system log files, make sure that the size of the output data does not exceed 2 gigabytes by specifying appropriate options to narrow the data to be output.
3. The system activity statistical information consists of too many columns to be imported to Excel as is. Use the Excel text file wizard to delete unneeded columns before importing the data.