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

Hi Martin,

I made everything you said but it doesn't work.
See the other posts that I send to the other answers.

Thanks a lot.


"Martin Fuerderer" <MARTINFU@de.ibm.com> escreveu na mensagem
news:1107945501.7083145c04dbefc20060795448fe2351@t eranews...
>
> 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