The following table shows the tuning information that can be collected from the system log.

Table 22-6 Tuning information that can be collected from the system log

Type of statistical information		Explanation
Index statistical information	idx	Outputs information related to index page splits from within the index statistical information.
CONNECT/DISCONNECT statistical information#	cnc	Outputs (to a DAT file only) statistical information on CONNECTs and DISCONNECTs.

#: In the case of a HiRDB parallel server configuration, this statistical information is output to the front-end server's system log file.

The following figure shows the procedure for collecting tuning information (collecting tuning information from the system log).

Figure 22-4 Procedure for collecting tuning information (collecting tuning information from the system log)

Explanation

1. HiRDB collects system log information in system log files.
2. Use the pdlogunld command to unload system log files and create unload log files.
   When unload log files are output to multiple server machines in a HiRDB parallel server configuration, the OS's rcp command (remote copy) or NFS (network file system) can be used to collect the unload log files.
   System log information can also be read directly by the statistics analysis utility. For details on the statistics analysis utility, see the manual HiRDB Version 9 Command Reference.
   
3. Execute the statistics analysis utility using the created unload log files as the input information. You can then use the execution results to tune HiRDB or UAPs.