10.10.1 Using the HADB server's statistical information
In the HADB server's statistical information, you can check the server's overall memory usage and its operational status.
For example, if you want to change the value of an operand specified in the server definition, you can use the HADB server's statistical information.
- Organization of this subsection
(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).
(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
-
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.
-
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.
You can also use the HADB server's statistical information and related information when you perform the following types of tuning: