10.10.1 Using the HADB server's statistical information

(1) Outputting the HADB server's statistical information and acquiring related information

When you execute the adbstat command, the HADB server's statistical information is output. This output information displays differences from previously output information. Therefore, if you want to check the HADB server's operational status in a given time period, we recommend that you output its statistical information on a regular basis.

■ Outputting the HADB server's statistical information

See Checking the operational status of the entire system in Examples under adbstat (Perform Statistical Analysis of the HADB Server) in the manual HADB Command Reference.

We also recommend that you acquire the following types of related information when you output the HADB server's statistical information:

• Server message log files

  Use the OS's cp command or a similar method to copy and acquire these files. For the storage destination of server message log files, see 10.4.2 Viewing the message logs (message log output destination).

To Page Top

(2) Using the HADB server's statistical information and related information

By acquiring the HADB server's statistical information and related information on a regular basis, you can check the changes in the HADB server's operational status. You can also use the acquired HADB server's statistical information and related information to perform tuning.

■ Using the HADB server's statistical information and related information

1. Check the output date and time of the HADB server's statistical information.

   Check the Timestamp date and time (the output date and time of the HADB server's statistical information) that is output under the HADB server's statistical information.

2. Compare the Timestamp date and time with the output dates and times in the server message log file.

   Compare the Timestamp date and time you checked in step 1 with the output dates and times of the messages in the server message log file. By comparing the Timestamp date and time with the output dates and times of the messages, you can determine what type of processing the HADB server was performing.

The following figure shows the concept of using the HADB server's statistical information and related information.

Figure 10‒8: Using the HADB server's statistical information and related information

You can also use the HADB server's statistical information and related information when you perform the following types of tuning:

• 13.1.5 Preventing SQL statement execution wait status from occurring

• 13.1.11 Changing the file configuration of the work table DB area

• 13.4.1 Reducing the usage of shared memory to which HugePages is applied

To Page Top