Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

locks_prim

The locks_prim table describes each outstanding lock request in the current installation.  This table returns one row for each outstanding lock request.

 
Attribute Name Key Datatype Description
vnode 1 varchar(64) Ingres virtual node name
lock_id 2 integer4 Internal lock identifier.
attribute_s 0 varchar(32) Character representation of lock attribute.
attribute 0 integer4 Numeric lock attribute, 0x1 LKB_PHYSICAL, 0x2 LKB_TEMPORARY, 0x4 LKB_CANCEL, 0x8 LKB_ENQWAIT, 0x10 LKB_CONCANCEL, 0x20 LKB_PROPOGATE.
lkb_count 0 integer4 Count of physical requests for the lock.
grant_mode_s 0 varchar(12) Lock mode at which the lock has been granted (string).
grant_mode 0 integer4 Lock mode at which the lock has been granted (numeric) 0x0 NULL, 0x1 IS, 0x2 IX, 0x3 S, 0x4 SIX, 0x5 X.
status_block 0 integer4 Lock id status block.
value0 0 integer4 First part of lock value block.
value1 0 integer4 Second part of lock value block.
locklist_id 0 integer4 Internal numeric locklist identifier
req_mode_s 0 varchar(12) Lock mode at which the lock was requested (string).
req_mode 0 integer4 Lock mode at which the lock was requested, 0x0 NULL, 0x1 IS, 0x2 IX, 0x3 S, 0x4 SIX, 0x5 X.
resource_id 0 integer4 Internal identifier of the resource being locked.
lock_state_s 0 varchar(12) Current lock state (string).
lock_state 0 integer4 Current lock state (numeric), 1 LKB_GRANTED, 2 LKB_CONVERT, 3 LKB_WAITING.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.