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