onstat -P

Use the -P option to display for all partitions the partition number and the pages in the buffer pool that belong to the partition.

Example Output

Figure 107. onstat -P Output

IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 18:44:15 -- 34816 Kbytes
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: Is the size of the buffer pool pages in bytes
partnum: Is the partition number
total: Is the total number of partitions
btree: Is the number of B-tree pages in the partition
data: Is the number of data pages in the partition
other: Is the number of other pages in the partition
resident: Is the number of resident pages in the partition
dirty: Is the number of dirty pages in the partition