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 OneDB™ Performance Guide.