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. |