40.5.3 List of items that are output as global buffer statistical information

1

Type

Type of information that is output:

BUF: Global buffer statistical information

N

2

Timestamp

Date and time the global buffer statistical information was output

The date and time the adbstat command was executed (and global buffer 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 the corresponding global buffer's statistical information was output are displayed in the following format:

"YYYY-MM-DDΔhh:mm:ss.nnnnnn"^#1

Note, however, that the time at which the HADB server started is output if the statistical information for the relevant global buffer is output for the first time since the HADB server was started.^#2

Y

4

DBbuff_name

Global buffer name

Y

5

DBbuff_page_num

Total number of global buffer sectors

This item is related to the -p option of the adbbuff operand in the server definition.

It is the number of buffer sectors in existence when the adbstat command was executed.

Output format:

• Unsigned 8-byte integer

N

6

DBbuff_page_use_cnt

Number of global buffer sectors that have been allocated

This item is related to the -p option of the adbbuff operand in the server definition.

It is the number of buffer sectors that have been allocated when the adbstat command was executed.

Output format:

• Unsigned 8-byte integer

N

7

DBbuff_page_request_cnt

Number of page requests for the global buffer

This item is related to the -p option of the adbbuff operand in the server definition.

It is the number of requests issued 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

8

DBbuff_page_hit_cnt

Global buffer page hit count

This item is related to the -p option of the adbbuff operand in the server definition.

It indicates the hit count 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

9

DBbuff_page_hit_rate

Global buffer page hit rate^#3 (%)

This item is related to the -p option of the adbbuff operand in the server definition.

It is the hit rate during execution of the adbstat command.

Output format:

• Unsigned 8-byte integer

N

10

DBbuff_page_pagein_cnt

Global buffer page-in count

This item is related to the -p option of the adbbuff operand in the server definition.

It is the page-in count 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

11

DBbuff_page_pageout_cnt

Global buffer page-out count

This item is related to the -p option of the adbbuff operand in the server definition.

It is the page-out count 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

12

DBbuff_page_read_cnt

Number of times files were read into the global buffer

This item is related to the -p option of the adbbuff operand in the server definition.

It is the number of times files were read 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

13

DBbuff_page_write_cnt

Number of times data was written from the global buffer to files

This item is related to the -p option of the adbbuff operand in the server definition.

It is the number of times data was written to files 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

DBbuff_page_rng_num

Total number of range index buffer sectors

This item is related to the -a option of the adbbuff operand in the server definition.

It is the number of buffer sectors in existence when the adbstat command was executed.

Output format:

• Unsigned 8-byte integer

N

15

DBbuff_page_rng_use_cnt

Number of range index buffer sectors that have been allocated

This item is related to the -a option of the adbbuff operand in the server definition.

It is the number of buffer sectors that have been allocated when the adbstat command was executed.

Output format:

• Unsigned 8-byte integer

N

16

DBbuff_page_rng_request_cnt

Number of page requests for range index buffers

This item is related to the -a option of the adbbuff operand in the server definition.

It is the number of requests issued 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

17

DBbuff_page_rng_hit_cnt

Page hit count in range index buffer

This item is related to the -a option of the adbbuff operand in the server definition.

It is the hit count 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

18

DBbuff_page_rng_hit_rate

Page hit rate in range index buffer^#3 (%)

This item is related to the -a option of the adbbuff operand in the server definition.

It is the hit rate during execution of the adbstat command.

Output format:

• Unsigned 8-byte integer

N

19

DBbuff_page_rng_pagein_cnt

Range index buffer page-in count

This item is related to the -a option of the adbbuff operand in the server definition.

It is the page-in count 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

20

DBbuff_page_rng_pageout_cnt

Range index buffer page-out count

This item is related to the -a option of the adbbuff operand in the server definition.

It is the page-out count 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

21

DBbuff_page_rng_read_cnt

Number of times files were read into range index buffers

This item is related to the -a option of the adbbuff operand in the server definition.

It is the number of times files were read 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

22

DBbuff_page_rng_write_cnt

Number of times data was written from range index buffers to files

This item is related to the -a option of the adbbuff operand in the server definition.

It is the number of times data was written to files 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

23

DBbuff_tblscan_request_cnt

Number of page requests for table scan buffers

This item is related to the -k and -v options of the adbbuff operand in the server definition.

It is the number of requests issued 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

24

DBbuff_tblscan_hit_cnt

Table scan buffer page hit count^#4

This item is related to the -k and -v options of the adbbuff operand in the server definition.

It is the hit count 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

25

DBbuff_tblscan_hit_rate

Table scan buffer page hit rate^{#3, #4} (%)

This item is related to the -k and -v options of the adbbuff operand in the server definition.

It is the hit rate during execution of the adbstat command.

Output format:

• Unsigned 8-byte integer

N

26

DBbuff_tblscan_pagein_cnt

Table scan buffer page-in count^#4

This item is related to the -k and -v options of the adbbuff operand in the server definition.

It is the page-in count 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

27

DBbuff_tblscan_read_cnt

Number of times files were read into table scan buffers^#5

This item is related to the -k and -v options of the adbbuff operand in the server definition.

It is the number of times files were read 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

28

DBbuff_tblscan_failed_cnt

Number of times a buffer shortage occurred in table scan buffer

This item is related to the -k and -v options of the adbbuff operand in the server definition.

It is the number of times a buffer shortage occurred 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

29

DBbuff_tblscan_reuse_cnt

Number of table scan buffer sectors reused

This item is related to the -k and -v options of the adbbuff operand in the server definition.

The output number is the number of buffer sectors reused 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

30

DBbuff_tblscan_read_size

Size of files read into the table scan buffer (kilobytes)

This item is related to the -k and -v options of the adbbuff operand in the server definition.

This value is the size of files that were read 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

31

DBbuff_page_wait_cnt

This value is used by the system.

N

32

DBbuff_page_read_request_cnt

Number of requests to read files into the global buffer

This value is the number of requests issued 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

33

DBbuff_page_write_request_cnt

Number of requests to write data from the global buffer to files

This value is the number of requests issued 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

34

DBbuff_page_rng_read_request_cnt

Number of requests to read files into the range index buffer

This value is the number of requests issued 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

35

DBbuff_page_rng_write_request_cnt

Number of requests to write data from the range index buffer to files

This value is the number of requests issued 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