40.5.2 List of items that are output as connection operation information

The table below lists the titles of the items (columns) that are output as connection operation information and the content that is output. The columns are output in the order listed in the table.

Table 40‒5: Columns output as connection operation information
No.	Column title	Information that is output	Enclosing character
1	`Type`	Type of information that is output: `CNCT`: Connection operation information	N
2	`Timestamp`	Date and time the connection operation information was output The date and time when the `adbstat` command was executed (and when the connection operation information was output) are displayed in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss.nnnnnn"`^#1	Y
3	`Last_execute_time`	Date and time of the previous output The last date and time connection operation information was output for the corresponding connection are displayed in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss.nnnnnn"`^#1 If this is the first time activity information has been output since the corresponding connection was established, the date and time that connection was established are displayed.^{# 2}	Y
4	`AP_name`	Application identifier For a connection from an application program The application identifier specified in the `adb_clt_ap_name` operand in the client definition is output. If the `adb_clt_ap_name` option is omitted, `********` is output. For a connection from a command The command name is output. In the case of the `adbsql` command, the application identifier specified in `adb_clt_ap_name` in the client definition is output.	Y
5	`Connection_num`	Connection sequence number This is the connection sequence number assigned since the HADB server started. Output format: Signed 4-byte integer	N
6	`Connect_time`	Date and time the connection was established The date and time the corresponding connection was established is output in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss.nnnnnn"`^#1	Y
7	`Tran_start_cnt`	Transaction start count^#3 This is the number of times transactions were started since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
8	`Tran_commit_cnt`	Commit count^#4 This is the number of times transactions were committed since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
9	`Tran_rollback_cnt`	Rollback count^#4 This is the number of times transactions were rolled back since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
10	`SQL_execute_wait_total_time`	Total wait time for SQL statement execution (seconds) This is the total amount of time that execution of SQL statements was in wait status since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 seconds.	N
11	`SQL_execute_wait_cnt`	SQL statement execution wait count This is the number of times execution of SQL statements was placed in wait status since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
12	`Multi_stmt_insufficient_thd_cnt`	Number of times a shortage of processing threads occurred when multiple statement handles were executed concurrently This is the number of times a shortage of threads occurred since the last time connection operation information on the corresponding connection was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
13	`SELECT_cnt`	Number of times the `SELECT` statement was executed This is the number of times the `SELECT` statement was executed since the last time the corresponding connection operation information was output. An execution of the `SELECT` statement is counted when the cursor open processing has terminated normally. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
14	`SELECT_total_time`	`SELECT` statement execution time (seconds) This is the amount of time spent on execution of `SELECT` statements since the last time the corresponding connection operation information was output. This value includes the execution time of `SELECT` statements that terminated abnormally. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 seconds.	N
15	`Fetch_row_cnt`	Number of fetched rows^#5 This is the number of rows fetched since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 rows.	N
16	`INSERT_cnt`	Number of times the `INSERT` statement was executed This is the number of times the `INSERT` statement was executed since the last time the corresponding connection operation information was output. An execution of an `INSERT` statement that terminated abnormally is not included in the count. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
17	`INSERT_total_time`	`INSERT` statement execution time (seconds) This is the amount of time spent on execution of `INSERT` statements since the last time the corresponding connection operation information was output. This value includes the execution time of `INSERT` statements that terminated abnormally. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 seconds.	N
18	`UPDATE_cnt`	Number of times the `UPDATE` statement was executed This is the number of times the `UPDATE` statement was executed since the last time the corresponding connection operation information was output. An execution of an `UPDATE` statement that terminated abnormally is not included in the count. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
19	`UPDATE_total_time`	`UPDATE` statement execution time (seconds) This is the amount of time spent on execution of `UPDATE` statements since the last time the corresponding connection operation information was output. This value includes the execution time of `UPDATE` statements that terminated abnormally. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 seconds.	N
20	`DELETE_cnt`	Number of times the `DELETE` statement was executed This is the number of times the `DELETE` statement was executed since the last time the corresponding connection operation information was output. An execution of a `DELETE` statement that terminated abnormally is not included in the count. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
21	`DELETE_total_time`	`DELETE` statement execution time (seconds) This is the amount of time spent on execution of `DELETE` statements since the last time the corresponding connection operation information was output. This value includes the execution time of `DELETE` statements that terminated abnormally. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 seconds.	N
22	`Update_row_cnt`	Number of rows updated^#6 This is the number of rows updated since the last time the corresponding connection operation information was output. The SQL statements subject to counting of the number of rows updated include the `INSERT`, `UPDATE`, and `DELETE` statements. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 rows.	N
23	`TRUNCATE_TABLE_cnt`	Number of times the `TRUNCATE` `TABLE` statement was executed This is the number of times the `TRUNCATE` `TABLE` statement was executed since the last time the corresponding connection operation information was output. An execution of a `TRUNCATE` `TABLE` statement that terminated abnormally is not included in the count. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
24	`TRUNCATE_TABLE_total_time`	`TRUNCATE` `TABLE` statement execution time (seconds) This is the amount of time spent on execution of `TRUNCATE` `TABLE` statements since the last time the corresponding connection operation information was output. This value includes the execution time of `TRUNCATE` `TABLE` statements that terminated abnormally. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 seconds.	N
25	`PURGE_CHUNK_cnt`	Number of times the `PURGE` `CHUNK` statement was executed This is the number of times the `PURGE` `CHUNK` statement was executed since the last time the corresponding connection operation information was output. An execution of a `PURGE` `CHUNK` statement that terminated abnormally is not included in the count. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
26	`PURGE_CHUNK_total_time`	`PURGE` `CHUNK` statement execution time (seconds) This is the amount of time spent on execution of `PURGE` `CHUNK` statements since the last time the corresponding connection operation information was output. This value includes the execution time of `PURGE` `CHUNK` statements that terminated abnormally. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 seconds.	N
27	`Hashgrp_area_max_size`	Maximum usage of the hash group area^#7 (bytes) This is the highest amount of usage between the time the corresponding connection was established and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer	N
28	`Hashgrp_area_get_cnt`	Number of times the hash group area was allocated^#7 This is the number of allocations between the time the corresponding connection was established and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
29	`Hashtbl_area_max_size`	Maximum usage of the hash table area (bytes) This is the highest amount of usage between the time the corresponding connection was established and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer	N
30	`DBbuff_wrktbl_clt_read_cnt`	Number of times files were read into the local work table buffer This is the number of times files were read since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
31	`DBbuff_wrktbl_clt_write_cnt`	Number of times data was written from the local work table buffer to files This is the number of times data was written to files since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
32	`Log_usrbuf_out_cnt`	Flush count due to full user log buffer This is the number of times flushing occurred since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
33	`Log_usrfile_max_size`	Maximum usage of user log files (bytes) This is the highest amount of usage between the time the corresponding connection was established and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer	N
34	`DBarea_extension_cnt`	DB area automatic extension count This is the number of times automatic extension of DB area files (regular files) has occurred since the last time the corresponding connection operation information was output.^{# 8} Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
35	`Log_usrfile_write_cnt`	Number of times user log files have been written This is the number of times user log files have been written since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
36	`DBbuff_wrktbl_clt_request_fix_cnt`	This value is used by the system.	N
37	`DBbuff_wrktbl_clt_pagein_fix_cnt`	This value is used by the system.	N
38	`DBbuff_wrktbl_clt_pageout_fix_cnt`	This value is used by the system.	N
39	`DBbuff_blk_pagein_cnt`	This value is used by the system.	N
40	`DBbuff_blk_pageout_cnt`	This value is used by the system.	N
41	`DBbuff_blk_read_cnt`	This value is used by the system.	N
42	`DBbuff_blk_write_cnt`	This value is used by the system.	N
43	`Directory_send_num`	Number of times directory information was sent This is the number of times directory information has been sent since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
44	`Directory_recv_num`	This value is used by the system.	N
45	`Log_send_num`	This value is used by the system.	N
46	`Log_recv_num`	This value is used by the system.	N
47	`DBbuff_send_num`	This value is used by the system.	N
48	`DBbuff_recv_num`	This value is used by the system.	N
49	`Node_com_num`	Number of times communication took place between nodes This is the number of times communication has taken place since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615.	N
50	`Node_com_time`	Communication time between nodes (microseconds) This is the time that has been used for communication since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer The count is reset to `0` once it reaches 18,446,744,073,709,551,615 microseconds.	N
51	`Log_usrfile_reduced_cnt`	Number of times user log files were reduced to the initialization size This is the number of times user log files were reduced to the initialization size since the last time the corresponding connection operation information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N

Legend:

Y: The output value is enclosed in a pair of enclosing characters.

N: The output value is not enclosed in the enclosing character.

#1

The year (YYYY) is output as four digits. The month (MM), day (DD), hour (hh), minute (mm), and second (ss) are each output as two digits. The microsecond (nnnnnn) is output as six digits. If there are not enough digits, leading zeros are added. Δ indicates a single-byte space.

#2

The following figure shows the date and time that are output as the date and time of the previous output:

[Figure]

When connection operation information is output for the first time since connections A and B were established, what is displayed for the date and time of the previous output is the date and time each connection was established. The next time that connection operation information is output, the date and time of the previous output will be the date and time of the last output of the corresponding connection operation information.

#3

This includes both the number of times transactions were started explicitly by application programs and the number of times transactions were started implicitly by the system at the time the HADB server started and during command execution.

#4

This includes both the number of times transactions were terminated explicitly from application programs by issuing the COMMIT or ROLLBACK statement and the following values:

Number of times transactions were committed implicitly when definition SQL statements were executed
Number of times transactions were rolled back implicitly due to an SQL error
Number of times transactions were terminated implicitly by the system during command execution

#5

This is the number of rows fetched on the HADB server. If an error occurs in an SQL statement using batch transfer of retrieval results, the displayed value might differ from the actual number of rows fetched by the application program.

The fetched row count does not include the number of rows retrieved when the following commands were executed:

adbarchivechunk command
adbexport command
adbgetcst command
adbidxrebuild command
adbmergechunk command
adbreorgsystemdata command

#6

If an error occurs in an SQL statement using batch transfer of retrieval results, the rows that were updated successfully before the error occurred are counted. These rows are counted as updated rows even if the processing is rolled back implicitly.

#7

If local hash grouping processing is applied, as many hash grouping areas are allocated as the number of SQL processing real threads. If local hash grouping processing is applied within a subquery that contains an external reference column, local hash grouping processing is performed as many times as the number of rows outside the subquery. Therefore, as many hash grouping areas are allocated as the value obtained from the following formula:

number-of-rows-in-external-queries × number-of-SQL-processing-real-threads

#8

This does not include automatic extensions for the work table DB area. To determine whether automatic extension has occurred for the work table DB area, check the Wrktbl_page_use_max value in No. 13 in Table 40‒4: Columns output as HADB server statistical information in 40.5.1 Items that are output as HADB server statistical information.

To Page Top