PAGELOCKS
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 |
|
PARTITIONID |
FIXED(5) |
Identification of the partition |
|
TASKID |
FIXED(10) |
Identification 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