Show TOC

Object documentationSPINLOCKPOOLSTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.SPINLOCKPOOLSTATISTICS describes pooled internal lock mechanisms and actions performed using them since the last start of the database.

Structure

SPINLOCKPOOLSTATISTICS

SPINLOCKPOOLNAME

CHAR(40)

Name of the spin lock pool

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