System Administrator Guide > System Administrator Guide > Understanding Ingres Management Architecture > Query Examples on IMA Tables > Example: Shutting Down a DBMS Server
Was this helpful?
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');
Linux:
update ima_mib_objects
set value     = '1'
where classid = 'exp.clf.unix.cs.mon.shutserver'
and instance  = '0'
and server    = DBMSINFO('IMA_SERVER');
Last modified date: 08/14/2024