Re: Multiple informix installations.

Hi, assuming that only one instance is running, you can check for the "oncfg_..." file that each instance is maintaining (this is not the $ONCONFIG file, it's a file created and maintained by the server). The complete file name is something like "$INFORMIXDIR/etc/oncfg_<servername>.<servernumber>" So you simply have to get a list of all the suspected installation directories and run a "ls -ltr" like the following: ls -ltr <dir_1>/etc/oncfg_* <dir_2>/etc/oncfg_* ... The newest (most up-to-date) oncfg_... file will be the one of the running server. So from this you know the server number and the server name. You can then in the directory where that oncfg_... file is do a grep for this server name and/or server number to find out the correct $ONCONFIG file (hopefully there are no old copies lying around, i.e. hopefully this will give you just a single $ONCONFIG file name). With that you can then set: $INFORMIXDIR, $INFORMIXSERVER, $ONCONFIG This leaves you with the problem of $INFORMIXSQLHOSTS. If the sqlhosts file is "$INFORMIXDIR/etc/sqlhosts" then you don't need to set $INFORMIXSQLHOSTS env variable. But actually the sqlhosts file (containing the connection info) can be of any name in any directory on the system ... :-( So that might leave you with a bit of guesswork. BTW: To be just a bit rude ... ;-) The issue here is not (only) knowing that certain env variables (see above) need to be set. The issue is, that there are several installation directories, each possibly containing several $ONCONFIG files, etc. And finding the actual one out of these (without other information) to be able to correctly set the environment variables for a specific instance - that can really be less than trivial ... Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 08.02.2005 17:28:04: > Hi group, > > I'm starting administering an AIX (Unix) server with informix installed on > it. I need to access the informix database because I have to make a new > program that should use the same database, so that all the data inserted > before could be used. > The problem is that I found multiple installations of informix and I can't > run the standard commands (onstat, oninit, etc) in anyone. > I've got 5 informix directories at the the root (/): > - OKinformix > - INFORMIXTMP > - informix > - oldinformix > - sdkinformix > > How do I know what installation is?? > I go to the bin directory of all of them but when I try to run "./onstat" I > receive this error: > GLS initialization failed, error -23101 > I know that the database is running but I can't find where!! > What could be the problem? Can anyone help me? > > Best regards, > Nuno Paquete sending to informix-list