10. Understanding Ingres Management Architecture : Management Domains : Restoring the Domain
 
Share this page                  
Restoring the Domain
To return the domain for the MIB server to the original default, it is necessary to update the classid 'exp.gwf.gwm.session.control.reset_domain'. Doing so does not actually change the value in the ima_mib_objects table, but is an instruction to remove the objects from the visible domain.
The following SQL update restores the domain:
UPDATE ima_mib_objects
SET    value        = DBMSINFO('IMA_VNODE')
WHERE  classid      = 'exp.gwf.gwm.session.control.reset_domain'
AND    instance     = '0'
AND    server       = DBMSINFO('IMA_SERVER');
To simplify this process further, the IMADB database contains database procedures:
ima_set_server_domain
This procedure takes no parameters. It updates the 'exp.gwf.gwm.session.control.reset_domain' object.
ima_set_vnode_domain
This procedure sets the IMA domain to the current vnode. It updates the 'exp.gwf.gwm.session.control.add_vnode' object.