Monitor blobspace usage with oncheck -pe
The oncheck -pe command provides information
about blobspace usage:
- Names of the tables that store TEXT and BYTE data, by chunk
- Number of disk pages (not blobpages) used, by table
- Number of free disk pages remaining, by chunk
- Number of overhead pages used, by chunk
The following example shows sample oncheck -pe output.
BLOBSpace Usage Report: fstblob Owner: informix Created: 03/01/08
Chunk: 3 /home/server/blob_chunk Size Used Free
4000 304 3696
Disk usage for Chunk 3 Total Pages
------------------------------------------------------
OVERHEAD 8
stores_demo:chrisw.catalog 296
FREE 3696