Determine blobpage fullness with oncheck -pB

The oncheck -pB command displays statistics that describe the average fullness of blobpages. If you find that the statistics for a significant number of simple large objects show a low percentage of fullness, the database server might benefit from changing the size of the blobpage in the blobspace.

Run oncheck -pB with either a database name or a table name as a parameter. The following example retrieves storage information for all simple large objects stored in the table sriram.catalog in the stores_demo database:
oncheck -pB stores_demo:sriram.catalog 

For detailed information about interpreting the oncheck -pB output, see optimizing blobspace blobpage size in the chapter on table performance considerations in the HCL Informix® Performance Guide.

Copyright© 2018 HCL Technologies Limited