Object documentationPAGELOCKS Locate this document in the navigation structure

 

This system view SYSINFO.PAGELOCKS can be used to determine the state of locked or requested data pages in the data cache.

Structure

PAGELOCKS

ROOTPAGENUMBER

FIXED(20)

Locked or requested page belongs to the file with this root page number

PAGENUMBER

FIXED(20)

Page number of locked or requested page

RECOVERYMODE

CHAR(10)

Type of page (PERMANENT | TEMPORARY | STATIC)

FILESYSTEMID

FIXED(5)

Identification of the file system

TASKID

FIXED(10)

ID of the lock or request holder

USAGECOUNT

FIXED(10)

Number of lock or request holders

LOCKMODE

CHAR(10)

Type of lock (NULL value | SHARE | EXCLUSIVE)

REQUESTMODE

CHAR(10)

Type of lock request (NULL value | SHARE | EXCLUSIVE)

More Information

Concepts of the Database System, How Databases Store Data and Log Entries, Working Memory Areas