onstat -b command: Print buffer information for buffers in use

Use the onstat -b option to display information about the buffers that are currently in use, including the total number of resident pages in the buffer pool.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -b-------------------------------------------------><

The maximum number of buffers available is specified in the buffers field in the BUFFERPOOL configuration parameter in the ONCONFIG file.

The onstat -b command also provides summary information about the number of modified buffers, the total number of resident pages in the buffer pool, the total number of buffers available, the number of hash buckets available, and the size of the buffer in bytes (the page size).
123 modified, 23 resident, 2000 total, 2048 hash buckets, 2048 buffer size. 

For information about displaying information about all buffers, use onstat -B command: Prints information about used buffers.

Example output

Following is sample output from the onstat -b command. For a description of the output, see onstat -B command: Prints information about used buffers.

Figure 1. onstat -b command output
Buffer pool page size: 4096

address         userthread flgs pagenum memaddr         nslots pgflgs xflgs owner waitlist
70000001097e9e8 0           c07 1:47841 7000000118e0000 10     1      0     0     0
700000010982188 0           807 1:47827 700000011939000 225    90     10    0     0
2011 modified, 50000 total, 65536 hash buckets, 4096 buffer size