System Administrator Guide > System Administrator Guide > Understanding Ingres Management Architecture > Control Objects
Was this helpful?
Control Objects
In the same way that there are control objects that can be updated to add or delete a VNODE from a MIB server domain, there are other control objects that can be updated using the SQL statement UPDATE.
The following is a sample of some of the control objects and their effects:
exp.scf.scd.server.control.close
Sets a DBMS server closed
exp.scf.scs.scb_remove_session
Removes a session from a DBMS server
exp.scf.scd.server.control.open
Sets a DBMS server open
exp.scf.scd.server.control.shut
Sets a DBMS server shut
exp.scf.scd.server.control.start_sampler
Start sampling on a DBMS server
exp.scf.scd.server.control.stop_sampler
Stop sampling on a DBMS server
exp.scf.scd.server.control.stop
Stops a DBMS server
exp.scf.scd.server.control.crash
Causes a DBMS server to CRASH
exp.gcf.gcn.local_vnode
Set/unset the name of the local_vnode
exp.gcf.gcn.remote_vnode
Set/Unset the name of remote_vnode
To simplify using some of these control objects, the IMADB database contains the following database procedures:
• ima_close_server
• ima_drop_all_sessions
• ima_drop_sessions
• ima_open_server
• ima_remove_session
• ima_shut_server
• ima_start_sampler
• ima_stop_sampler
Run the ima_drop_sessions procedure to remove all sessions from the current server (except own session) and ima_drop_all_sessions procedure to remove all sessions from all servers (except own session).
Last modified date: 08/14/2024