10. Understanding Ingres Management Architecture : Query Examples on IMA Tables : Example: Shutting Down a DBMS Server
 
Share this page                  
Example: Shutting Down a DBMS Server
This query marks the MIB server for shutdown when all sessions have exited:
Windows:
update ima_mib_objects
set value     = '1'
where classid = 'exp.clf.nt.cs.mon.shutserver'
and instance  = '0'
and server    = DBMSINFO('IMA_SERVER');
UNIX:
update ima_mib_objects
set value     = '1'
where classid = 'exp.clf.unix.cs.mon.shutserver'
and instance  = '0'
and server    = DBMSINFO('IMA_SERVER');