Object documentationSPINLOCKSTATISTICSRESET Locate this document in the navigation structure

 

The system table SYSINFO.SPINLOCKSTATISTICSRESET contains information about internal lock mechanisms since the last start RESET SPINLOCKSTATISTICS or RESET ALL.

Structure

SPINLOCKSTATISTICSRESET

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

More Information

SPINLOCKSTATISTICS