Object documentationSHARELOCKSTATISTICSRESET Locate this document in the navigation structure

 

The system table SYSINFO.SHARELOCKSTATISTICSRESET describes the critical sections and their use since the last RESET SHARELOCKSTATISTICS or RESET ALL.

Structure

SHARELOCKSTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

SHARELOCKADDRESS

CHAR(20)

Address in memory

EXCLUSIVEACCESSCOUNT

FIXED(20)

Number of exclusive accesses to this critical section

NONEXCLUSIVEACCESSCOUNT

FIXED(20)

Number of non-exclusive accesses to this critical section

COLLISIONCOUNT

FIXED(20)

Number of collisions between a task that is occupying the critical section and another task that is requesting the critical section

WAITCOUNT

FIXED(20)

Number of tasks waiting for access to the critical section

SPINLOCKCOLLISIONCOUNT

FIXED(20)

Number of task collisions in the management of the critical section

More Information

SHARELOCKSTATISTICS, SHARELOCKINFORMATION, SHARELOCKWAITINGTASKS

Concepts of the Database System, Working Memory Areas

Glossary, Critical Section