10.10.2 Using the connection operation information

(1) Outputting the connection operation information and acquiring related information

When you execute the adbstat command, the connection operation information is output. The output information displays differences from previously output information. Therefore, if you want to check the operational status of each connection made to the HADB server in a given time period, we recommend that you output the connection operation information on a regular basis while you are executing applications, commands, or SQL statements.

■ Outputting the connection operation information

See Checking the operational status of a specific application program 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 connection operation 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).

• Application identifier

  Use the adbls -d cnct command to check the application identifier that is set for the application or command being executed. In the case of an application, the application identifier that was specified in the adb_clt_ap_name operand in the client definition is output.

  For details about the adbls -d cnct command, see adbls -d cnct (Display the Connection Status) in the manual HADB Command Reference.

  For details about the adb_clt_ap_name operand in the client definition, see Operands related to application program status monitoring in the HADB Application Development Guide.

  Note

  If there are multiple applications, we recommend that you specify for each application a unique application identifier in the adb_clt_ap_name operand in the client definition.

To Page Top

(2) Using the connection operation information and related information

By acquiring the connection operation information and related information on a regular basis, you can check the operational status of each connection made to the HADB server. You can also use the acquired connection operation information and related information to perform tuning.

■ Using the connection operation information and related information

1. Check the connection operation information.

   In the connection operation information that is output, check the following information:

   • Timestamp (the output date and time of the connection operation information)

   • AP_name (application identifier)

2. Compare the Timestamp date and time with the server message log file.

   Compare the Timestamp date and time that 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 target connection was performing.

   Also, compare the AP_name information, which you checked in step 1, with the application identifier in message KFAA81000-I in the server message log file. By comparing the AP_name information with the application identifier, you can check the target application and command.

The following figure shows the concept of using the connection operation information and related information.

Figure 10‒9: Using the connection operation information and related information

You can also use the connection operation information and related information when you perform the following types of tuning:

• 13.1.6 Reducing the SQL statement processing time

• (1) Using the connection operation information to reduce the execution time of an SQL statement that creates a local work table in 13.2.4 Reducing the execution time of an SQL statement that creates a local work table.

To Page Top