SPINLOCKPOOLSTATISTICSRESET
The system table SYSINFO.SPINLOCKPOOLSTATISTICSRESET describes pooled internal lock mechanisms and actions performed using them since the last RESET SPINLOCKPOOLSTATISTICS or RESET ALL.
|
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
|
SPINLOCKPOOLNAME |
CHAR(40) |
Name of the spin lock pool |
|
PARTITIONID |
FIXED(5) |
Parition ID |
|
AVGLOCKCOUNT |
FIXED(20) |
Number of attempts to get the spin lock - average value within the pool |
|
MINLOCKCOUNT |
FIXED(20) |
Number of attempts to get the spin lock - minimum value within the pool |
|
MAXLOCKCOUNT |
FIXED(20) |
Number of attempts to get the spin lock - maximum value within the pool |
|
AVGCOLLISIONCOUNT |
FIXED(20) |
Number of failed attempts to get the spin lock - average value within the pool |
|
MINCOLLISIONCOUNT |
FIXED(20) |
Number of failed attempts to get the spin lock - minimum value within the pool |
|
MAXCOLLISIONCOUNT |
FIXED(20) |
Number of failed attempts to get the spin lock - maximum value within the pool |
|
AVGTOTALSPINLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU - average value within the pool |
|
MINTOTALSPINLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU - minimum value within the pool |
|
MAXTOTALSPINLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU - maximum value within the pool |
|
AVGTOTALYIELDLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU - average value within the pool |
|
MINTOTALYIELDLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU - minimum value within the pool |
|
MAXTOTALYIELDLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU - maximum value within the pool |
|
AVGMAXSPINLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU - average value within the pool |
|
MINMAXSPINLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU - minimum value within the pool |
|
MAXMAXSPINLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU - maximum value within the pool |
|
AVGMAXYIELDLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU - average value within the pool |
|
MINMAXYIELDLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU - minimum value within the pool |
|
MAXMAXYIELDLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU - maximum value within the pool |