SPINLOCKPOOLSTATISTICSRESET
The system table SYSINFO.SPINLOCKPOOLSTATISTICSRESET
describes pooled internal lock mechanisms and actions performed using them since the last RESET SPINLOCKPOOLSTATISTICS
or RESET ALL
.
|
TIMESTAMP |
Time of the last RESET for these entries |
|
CHAR(40) |
Name of the spin lock pool |
|
FIXED(5) |
Parition ID |
|
FIXED(20) |
Number of attempts to get the spin lock – average value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock – minimum value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock – maximum value within the pool |
|
FIXED(20) |
Number of failed attempts to get the spin lock – average value within the pool |
|
FIXED(20) |
Number of failed attempts to get the spin lock – minimum value within the pool |
|
FIXED(20) |
Number of failed attempts to get the spin lock – maximum value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU – average value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU – minimum value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU – maximum value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU – average value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU – minimum value within the pool |
|
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU – maximum value within the pool |
|
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU – average value within the pool |
|
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU – minimum value within the pool |
|
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU – maximum value within the pool |
|
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU – average value within the pool |
|
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU – minimum value within the pool |
|
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU – maximum value within the pool |