6.1.6 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 : 03-01(Apr 23 2015 15:32:27) Transaction ID : 1 Connection Number : 1 SQL Serial Number : 1
- Explanation:
-
-
Version
The version of the HADB server that ran the SQL statement for which the access path statistical information was acquired.
The information in parentheses is additional version information.
-
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.
-