10. Understanding Ingres Management Architecture : Query Examples on IMA Tables : Example: What Are User Sessions Doing?
 
Share this page                  
Example: What Are User Sessions Doing?
The following SQL shows what user sessions are currently doing in all servers in the local VNODE and the remote VNODE “GRFR6”:
update ima_mib_objects
set    value        = DBMSINFO('IMA_VNODE')
where  classid      = 'exp.gwf.gwm.session.control.add_vnode'
and    instance     = '0'
and    server       = DBMSINFO('IMA_SERVER');
 
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
       *
from
       ima_server_sessions
where db_owner != '';