Detecting server name for Ingres installation
Intro
Ingres can be installed several times on a single machine and depending on configurations, it can bring a bit of confusion (even if a basis exists in these environments).
The installation of Ingres can be done several times on a single machine and prior the configurations, this can however create a bit of confusion if the same base exists under different environments.
It is however very important to know the server name and the ingres installation code when connected via a node or a local.
Use
imadb to see the request:
How to display those information through
imadb:
SELECT
dbmsinfo('ima_vnode') as machine,
value as code_installation
FROM
ima_mib_objects
WHERE
classid = 'exp.gcf.gca.install_id'
Note
- Worked perfectly with Ingres 2.6 and Ingres 2006
- Not compatible with Ingres2.0 (no installation code)
- Not tested for Ingres 2.5
- Under Ingres2006 for VMS, the installation code is * through this method.