10. Understanding Ingres Management Architecture : Query Examples on IMA Tables : Example: Who Is Waiting for a Lock?
 
Share this page                  
Example: Who Is Waiting for a Lock?
The following query shows which sessions are waiting for locks in the VNODE "GRFR6":
update ima_mib_objects
set    value        = 'GRFR6'
where  classid      = 'exp.gwf.gwm.session.control.add_vnode'
and    instance     = '0'
and    server       = DBMSINFO('IMA_SERVER');
 
select distinct
       resource_id,
       lock_id,
       lock_state,
       ima_locklists.locklist_id,
       locklist_server_pid,
       locklist_session_id,
       effective_user,
       db_name,
       session_terminal,
       session_query
from
       ima_locks,
       ima_locklists,
       ima_server_sessions
where lock_state != 'GR'
and ima_locks.locklist_id = ima_locklists.locklist_id
and ima_locklists.locklist_server_pid = ima_server_sessions.server_pid
and ima_locklists.locklist_session_id = ima_server_sessions.session_id;