SPINLOCKPOOLSTATISTICSRESET

Definition

The system table SPINLOCKPOOLSTATISTICSRESET describes pooled internal lock mechanisms and consequently executed actions since the last RESET SPINLOCKPOOLSTATISTICS or RESET ALL.

Structure

SPINLOCKPOOLSTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

SPINLOCKPOOLNAME

CHAR(40)

Name of the spin lock pool

MAXLOCKCOUNT

FIXED(20)

Number of attempts to get the spin lock – maximum value within the pool ­ 

MINLOCKCOUNT

FIXED(20)

Number of attempts to get the spin lock – minimum value within the pool ­ 

AVGLOCKCOUNT

FIXED(20)

Number of attempts to get the spin lock – average value within the pool ­ 

MAXCOLLISIONCOUNT

FIXED(20)

Number of failed attempts to get the spin lock – maximum value within the pool ­ 

MINCOLLISIONCOUNT

FIXED(20)

Number of failed attempts to get the spin lock – minimum value within the pool ­ 

AVGCOLLISIONCOUNT

FIXED(20)

Number of failed attempts to get the spin lock – average 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 ­ 

MINTOTALSPINLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock without prior release of the CPU – minimum 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 ­ 

MAXTOTALYIELDLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock after prior release of the CPU – maximum 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 ­ 

AVGTOTALYIELDLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock after prior release of the CPU – average 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 ­ 

MINMAXSPINLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock without prior release of the CPU – minimum 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 ­ 

MAXMAXYIELDLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock after prior release of the CPU – maximum 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 ­ 

AVGMAXYIELDLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock after prior release of the CPU – average value within the pool ­ 

See also:

SPINLOCKPOOLSTATISTICS