onstat -P command: Print partition information

Use the onstat -P command to display the partition number and the pages in the buffer pool for all of the partitions.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -P-------------------------------------------------><

For information about running onstat -P on a dump file created without the buffer pool, see Running onstat Commands on a Shared Memory Dump File.

Example output

Figure 1. onstat -P command output
Buffer pool page size: 2048
partnum  total    btree    data     other    dirty   
0        36       1        8        27       0      
1048577  2        0        0        2        0       
1048578  4        1        1        2        0       
1048579  23       10       12       1        0       
1048580  68       31       36       1        0       
4194309  3        0        1        2        0       

Totals:  3000     786      1779     435      0       
Percentages:
Data  59.30 
Btree 26.20 
Other 14.50 

Buffer pool page size: 8192
partnum  total    btree    data     other    dirty   
0        999      0        0        999      0       
5242881  1        0        0        1        0       

Totals:  1000     0        0        1000     0       
Percentages:
Data  0.00  
Btree 0.00  
Other 100.00

Output description

Buffer pool page size
The size, in bytes, of the buffer pool pages.
partnum
The partition number.
total
The total number of partitions.
btree
The number of B-tree pages in the partition.
data
The number of data pages in the partition.
other
The number of other pages in the partition.
dirty
The number of dirty pages in the partition.

Copyright© 2019 HCL Technologies Limited