
The system table SYSINFO.SPINLOCKSTATISTICSRESET contains information about internal lock mechanisms since the last start RESET SPINLOCKSTATISTICS or RESET ALL.
|
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
|
NAME |
CHAR(40) |
Name of the spin lock |
|
LOCKCOUNT |
FIXED(20) |
Number of attempts to get the spin lock |
|
COLLISIONCOUNT |
FIXED(20) |
Number of failed attempts to get the spin lock |
|
SPINLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU |
|
YIELDLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU |
|
MAXSPINLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU |
|
MAXYIELDLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU |