14.4.2 DAT-format file unit

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. The table below lists the names of DAT-format files.

Table 14-5 Names of DAT-format files

Edited informationOutput unitFile name
System activity statistical informationActivity information in the log for one systemsys_DAT
UAP statistical informationExecution of one UAP or one serviceuap_DAT
SQL statistical informationExecution of one SQLsql_DAT
Global buffer pool statistical informationEach synchronization pointbuf_DAT
Statistical information about HiRDB files for database manipulationEach synchronization pointfil_DAT
Deferred write processing statistical informationEach time a parallel write process for deferred write processing startsdfw_DAT
Static optimization informationPreprocessing of one SQLsop_DAT
Dynamic optimization informationEach server within an SQLdop_DAT
SQL object execution informationEach parallel SQLpcd_DAT
SQL object transfer statistical informationEach parallel SQLobj_DAT
SQL statement statistical informationExecution of one SQLsqh_DAT
CONNECT/DISCONNECT statistical informationEach CONNECT/DISCONNECTcnc_DAT
Statistical information about database I/O operationsEach HiRDB file constituting the RDAREA in which I/O operations were performed during an information output intervaldio_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 cut command to delete unneeded columns before importing the data.
    The following is an example:
    cut -d "," -f1-256 /tmp/sys_DAT > /tmp/sys_DAT.out