FREEBLOCKMANAGERSTATISTICS
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 |
|
PARTITIONID |
FIXED(5) |
Identification of the partition |