40.1 Description
When the adbstat command is executed, HADB server operation information is output. The following figure provides an overview of the adbstat command.
|
|
![[Figure]](GRAPHICS/F0000167.GIF)
- Explanation:
-
When the adbstat command is executed, HADB server operation information is output to standard output in CSV format. You can redirect these output results to a file and forward the file to a spreadsheet program so that you can check the HADB server operation information in tabular format.
The statistics log file is used to store some of the HADB server operation information. For details about the statistics log file, see the topic Using the statistics log files in Performing statistical analysis (checking HADB server operation information) in Scheduled Operations in the HADB Setup and Operation Guide.
The adbstat command outputs four types of information:
-
HADB server statistical information
HADB server operational status information is output. Each execution of the adbstat command outputs only one line of HADB server statistical information.
-
Connection operation information
Connection operational status information is output. This information can be obtained and output for each connection that has been established with an application program.
-
Global buffer statistical information
Global buffer operational status information is output. This information can be obtained and output for each global buffer.
-
SQL statement statistical information
SQL statement operational status information is output. When the adbstat command is executed, information about the number of DB areas accessed by each SQL statement is output from the statistical information that has been output to the statistics log file. If an SQL statement did not access any DB areas, one line of SQL statement information is output.
In the case of SQL statements to which batch transfer of dynamic parameter values was applied, statistical information is output collectively for all those SQL statements as if the statistical information were for a single SQL statement. For details about batch transfer of dynamic parameter values, see the topic Batch transfer of dynamic parameter values in Designs Related to Improvement of Application Program Performance in the HADB Application Development Guide.
- Important
-
Access path statistical information is not output by the adbstat command. For details about access path statistical information, see the topic Examples of output of and output items for access path statistical information in Running SQL tracing in Scheduled Operations in the HADB Setup and Operation Guide.