This system view SYSINFO.PAGELOCKS can be used to determine the state of locked or requested data pages in the data cache.
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) |
Concepts of the Database System, How Databases Store Data and Log Entries, Working Memory Areas