Database Management Technology 
The locking_stats table contains locking system statistics for a specific Ingres installation (vnode). One row is returned for each vnode in the IMA management domain. The delta columns represent counter changes for the last interval.
| Attribute Name | Key | Datatype | Description |
| timestamp | 0 | date | Date and time the data was collected |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| delta_seconds | 0 | integer4 | Elapsed time (seconds) since the previous refresh. |
| locklists_used | 0 | integer4 | Count of lock lists in use. |
| locklists_used_d | 0 | integer4 | Change in locklists used in the last interval. |
| resources_used | 0 | integer4 | Count of resource blocks in use. |
| resources_used_d | 0 | integer4 | Change in resource blocks used in the last interval. |
| locks_used | 0 | integer4 | Count of outstanding lock requests. |
| locks_used_d | 0 | integer4 | Change in outstanding lock requests in the last interval. |
| list_creates | 0 | integer4 | Count of lock list create operations. |
| list_creates_d | 0 | integer4 | Count of lock list create operations in the last interval. |
| list_releases | 0 | integer4 | Count of lock list release operations. |
| list_releases_d | 0 | integer4 | Count of lock lists released in the last interval. |
| lock_requests | 0 | integer4 | Count of new lock requests. |
| lock_requests_d | 0 | integer4 | Count of new lock requests in the last interval. |
| lock_re_reqs | 0 | integer4 | Number of lock requests with implied conversions. |
| lock_re_reqs_d | 0 | integer4 | Number of lock requests with implied conversion in the last interval. |
| lock_converts | 0 | integer4 | Count of explicit lock conversion requests. |
| lock_converts_d | 0 | integer4 | Count of explicit lock conversion requests in the last interval. |
| lock_releases | 0 | integer4 | Count of physical lock release requests. |
| lock_releases_d | 0 | integer4 | Count of physical lock releases in the last interval. |
| lock_cancel | 0 | integer4 | Count of lock request timeout cancels. |
| lock_cancel_d | 0 | integer4 | Count of lock request timeouts in the last interval. |
| lock_escalates | 0 | integer4 | Count of lock requests resulting in escalations. |
| lock_escalates_d | 0 | integer4 | Count of lock escalations in the last interval. |
| lock_waits | 0 | integer4 | Count of lock requests forced to wait. |
| lock_waits_d | 0 | integer4 | Count of lock requests forced to wait in the last interval. |
| lock_searches | 0 | integer4 | Count of deadlock searches performed. |
| lock_searches_d | 0 | integer4 | Count of deadlock searches in the last interval. |
| lock_deadlocks | 0 | integer4 | Count of lock requests resulting in deadlocks. |
| lock_deadlocks_d | 0 | integer4 | Count of lock requests resulting in deadlocks in the last interval. |
| conv_waits | 0 | integer4 | Count of lock waits caused by lock conversions. |
| conv_waits_d | 0 | integer4 | Count of lock waits caused by conversion in the last interval. |
| conv_searches | 0 | integer4 | Count of deadlock searches caused by convert waits. |
| conv_searches_d | 0 | integer4 | Count of deadlock searches caused by conversion in the last interval. |
| conv_deadlocks | 0 | integer4 | Count of lock conversion requests resulting in deadlocks. |
| conv_deadlocks_d | 0 | integer4 | Coun of conversion deadlocks in the last interval. |
| res_long_chain_len | 0 | integer4 | Maximum resource overflow chain length. |
| res_long_chain_len_d | 0 | integer4 | Change in the resource overflow chain in the last interval. |
| lock_long_chain_len | 0 | integer4 | Maximum lock overflow chain length. |
| lock_long_chain_len_d | 0 | integer4 | Change in lock overflow chain length in the last interval. |
| block_allocs | 0 | integer4 | Count of allocate block operations. |
| block_allocs_d | 0 | integer4 | Count of block allocate operations in the last interval. |
| block_deallocs | 0 | integer4 | Count of deallocate block calls. |
| block_deallocs_d | 0 | integer4 | Count of block deallocate requests in the last interval. |
| lbk_highwater | 0 | integer4 | Highwater mark for LBK blocks. |
| lbk_highwater_d | 0 | integer4 | Change in LBK highwater mark in the last interval. |
| lkb_highwater | 0 | integer4 | Highwater mark for lock blocks in use. |
| lkb_highwater_d | 0 | integer4 | Change in highwater mark for locks in use in the last interval. |
| llb_highwater | 0 | integer4 | Highwater mark for locklists in use. |
| llb_highwater_d | 0 | integer4 | Change in highwater mark for locklists in use in the last interval. |
| max_lcl_dlk_srch | 0 | integer4 | Maximum length of a deadlock search. |
| max_lcl_dlk_srch_d | 0 | integer4 | Change in the size of the deadlock search list in the last interval. |
| rbk_highwater | 0 | integer4 | Highwater mark for RBK blocks in use. |
| rbk_highwater_d | 0 | integer4 | Change in the RBK block highwater in the last interval. |
| rsb_highwater | 0 | integer4 | Highwater mark for resource blocks in use. |
| rsb_highwater_d | 0 | integer4 | Change in the resource block highwater mark in the last interval. |
| sbk_highwater | 0 | integer4 | Highwater mark for SBK blocks in use. |
| sbk_highwater_d | 0 | integer4 | Change in highwater for SBK blocks in the last interval. |
