The system table SYSINFO.REGIONSTATISTICSRESET contains information about regions and their usage since the last RESET REGIONSTATISTICS or RESET ALL.
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
REGIONNAME |
CHAR(16) |
Name of region |
ACCESSCOUNT |
FIXED(20) |
Number of accesses to this region |
SPINLOCKCOLLISIONCOUNT |
FIXED(20) |
Number of collisions with internal mechanisms during use of this region |
WAITCOUNT |
FIXED(20) |
Number of collisions that resulted in use of the queue for this region |
COLLISIONCOUNT |
FIXED(20) |
Number of collisions between the task holding the region and another task that is waiting for this region |
COLLISIONRATE |
FIXED(10) |
Number of accesses that led to collisions |