Extending the Domain to a Remote Instance
To extend the domain to remote instance of Ingres, the instance must be reachable through Ingres Net. This can be done using netutil or VDBA. The login to the remote instance can either be done using an installation password or to a suitably privileged Ingres user, for example, "root".
The following SQL update extends the domain to a remote VNODE called "GRFR"”:
UPDATE ima_mib_objects
SET value = 'GRFR6'
WHERE classid = 'exp.gwf.gwm.session.control.add_vnode'
AND instance = '0'
AND server = DBMSINFO('IMA_SERVER');
The value 'GRFR' can be put into a program variable. Note that server is still the local MIB server as it is its domain that is being extended.
Last modified date: 01/30/2023