40.5.1 Items that are output as HADB server statistical information

The following table lists the titles of the items (columns) that are output as HADB server statistical information and the content that is output. The columns are output in the order listed in the table.

Table 40‒4: Columns output as HADB server statistical information
No.	Column title	Information that is output	Enclosing character
1	`Type`	Type of information that is output: `SYS`: HADB server statistical information	N
2	`Timestamp`	Date and time the HADB server statistical information was output The date and time the `adbstat` command was executed (and HADB server statistical 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 that HADB server statistical information was output are displayed in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss.nnnnnn"`^#1 If this is the first time HADB server statistical information has been output since the HADB server started, the date and time the HADB server started are displayed.	Y
4	`Total_memory_max_size`	Maximum amount of the entire memory that has been used (bytes) This is the highest amount of memory usage between the time the HADB server started and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer	N
5	`Share_memory_size`	Size of the area allocated for shared memory management and global buffer pages (bytes) This is the area size allocated during execution of the `adbstat` command. Output format: Unsigned 8-byte integer	N
6	`Proc_memory_max_size`	Maximum amount of process common memory that has been used (bytes) This is the highest amount of memory usage between the time the HADB server started and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer	N
7	`Rthd_memory_max_size`	Sum of the maximum usage amounts of all real thread private memory (bytes) This is the highest amount of memory usage between the time the HADB server started and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer	N
8	`Tran_start_cnt`	Transaction start count^#2 This is the number of times transactions were started since the last time HADB server statistical 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_commit_cnt`	Commit count^#3 This is the number of times transactions were committed since the last time HADB server statistical 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	`Tran_rollback_cnt`	Rollback count^#3 This is the number of times transactions were rolled back since the last time HADB server statistical 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
11	`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 HADB server statistical 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
12	`SQL_execute_wait_cnt`	SQL statement execution wait count This is the number of times that execution of SQL statements was placed in wait status since the last time HADB server statistical 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
13	`Wrktbl_page_use_max`	Maximum number of work table pages allocated This is the maximum number of pages allocated between the time the HADB server started and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
14	`Log_usrbuf_out_cnt`	Flush count due to full user log buffer This is the number of times flushing occurred since the last time HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
15	`Log_usrfile_max_size`	Maximum usage of user log file (bytes) This is the highest amount of memory usage between the time the HADB server started and the time the `adbstat` command was executed. Output format: Unsigned 8-byte integer	N
16	`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 HADB server statistical information was output.^#4 Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
17	`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 HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
18	`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 HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
19	`Log_mstfile_max_size`	This value is used by the system. Output format: Unsigned 8-byte integer	N
20	`Log_mstfile_reduced_cnt`	This value is used by the system. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
21	`Audit_file_write_cnt`	Number of times audit trail files have been written This is the number of times audit trail files have been written since the last time the HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
22	`Audit_file_write_size`	Data size written to the audit trail file (bytes) This is the size of data that has been written to the audit trail file since the last time the HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
23	`Audit_file_swap_cnt`	Number of times audit trail file has been swapped This is the number of times the audit trail file has been swapped since the last time the HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
24	`Tbldef_req_cnt`	Number of times acquisition of table-definition information was requested This is the number of times acquisition of table-definition information was requested since the last time HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
25	`Tbldef_access_cnt`	Number of times table-definition information was acquired from the dictionary table This is the number of times table-definition information was acquired from the dictionary table since the last time HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
26	`Tbldef_cache_access_cnt`	Number of times table-definition information was acquired from the table-definition pool This is the number of times table-definition information was acquired from the table-definition pool since the last time HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
27	`Tbldef_cache_register_cnt`	Number of times table-definition information was registered to the table-definition pool This is the number of times table-definition information was registered since the last time HADB server statistical information was output. Output format: Unsigned 8-byte integer If overflow occurs, `18446744073709551615` is output.	N
28	`Tbldef_cache_sweep_cnt`	Number of times table-definition information was purged from the table-definition pool This is the number of times table-definition information was purged since the last time HADB server statistical 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 in 4 digits. The month (MM), date (DD), hours (hh), minutes (mm), and seconds (ss) are each output in 2 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

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.

#3

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 at the time the HADB server started or during command execution

#4

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