System Administrator Guide > System Administrator Guide > Understanding Ingres Management Architecture > Query Examples on IMA Tables > Example: What Are User Sessions Doing?
Was this helpful?
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 != '';
Last modified date: 01/30/2023