6.1.7 Information output in identification information view (SQL statement identification information)

The identification information view displays SQL statement identification information that is used to identify the SQL statement for which HADB acquired access path statistical information. Based on the information displayed in this view, you can identify the correlation between the access path information and the access path statistical information.

For details about access path statistical information, see Examples of output of and output items for access path statistical information in the HADB Setup and Operation Guide.

The following is an example of the information displayed in the identification information view.

Output example

<<SQL Info >>
 
Version           : 05-03 May 25 2020 12:51:53
Transaction ID    : 1
Connection Number : 1
SQL Serial Number : 1

Explanation:

• Version

  The version and version add-on information of the HADB server where the SQL statement for acquiring the access path statistical information was executed.

• Transaction ID

  The transaction ID of the SQL statement for which the access path statistical information was acquired.

• Connection Number

  The connection sequence number of the SQL statement for which the access path statistical information was acquired.

• SQL Serial Number

  The SQL statement sequence number of the SQL statement for which the access path statistical information was acquired.

Note

This information corresponds to the following information in the SQL statement execution information output before the access path statistical information. The header name for the information is in parentheses.

• Transaction ID (tran_id)

• Connection sequence number (con_num)

• SQL statement sequence number (sql_serial_num)

For details about SQL statement execution information, see SQL statement execution information under Information that is output as SQL trace information in the HADB Setup and Operation Guide.

To Page Top