The system table SYSINFO.FREEBLOCKMANAGERSTATISTICSRESET contains information on block states since the last RESET FREEBLOCKMANAGERSTATISTICS or RESET ALL.
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
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 |