The system table SYSINFO.FREEBLOCKMANAGERSTATISTICS contains information on block states.
USEDVOLUMES |
FIXED(5) |
Number of used data volumes |
LASTUSEDVOLUME |
FIXED(5) |
Last requested block was on this volume |
TOTALBLOCKCOUNT |
FIXED(20) |
Number of usable blocks |
FREEBLOCKCOUNT |
FIXED(20) |
Number of free blocks |
OCCUPIEDBLOCKCOUNT |
FIXED(20) |
Number of occupied blocks |
SHADOWBLOCKCOUNT |
FIXED(20) |
Number of shadow blocks |
BACKUPBLOCKCOUNT |
FIXED(20) |
Number of occupied blocks in state backup |
BACKUPSHADOWBLOCKCOUNT |
FIXED(20) |
Number of shadow blocks in state backup |
SINGLEBLOCKREQUESTCOUNT |
FIXED(20) |
Number of requests for a single free block |
MULTIBLOCKREQUESTCOUNT |
FIXED(20) |
Number of requests for a multiple blocks |
MULTIBLOCKREQUESTEDCOUNT |
FIXED(20) |
Number of blocks requested |
MULTIBLOCKDELIVEREDCOUNT |
FIXED(20) |
Number of blocks delivered |
CLUSTERREQUESTCOUNT |
FIXED(20) |
Number of requests for cluster |
CLUSTERDELIVEREDCOUNT |
FIXED(20) |
Number of clusters delivered |
DATABASEFULLCOUNT |
FIXED(20) |
Number of database full situations detected by the free block management |