Nuno Paquete wrote:
> Hi group,
>
> I need to know which port is Informix listening because I need this
> information to configure an ODBC connection from Windows clients.
> The Informix database I need to connect is running on an AIX machine.
> When I run "netstat" command I get this information:
>
> Active Internet connections
> Proto Recv-Q Send-Q Local Address Foreign Address (state)
> tcp4 0 0 portonova.telnet 195.23.121.26.1123
> ESTABLISHED
> tcp4 0 0 loopback.49213 *.* LISTEN
> tcp4 0 0 loopback.smux loopback.32768
> ESTABLISHED
> tcp4 0 0 loopback.32768 loopback.smux
> ESTABLISHED
>
> Which port is it running? 49213 or 32768?
> I know that Informix database was running on this machine at the time I got
> the above information.
>
> Thanks in advance,
> Nuno Paquete
>
>

You need to understand how it is setup...
Each Informix instance can be listening on one or more ports (or zero,
but more on this later).

With the Informix environment setup you will have 4 environment
variables that are important for this:

1- INFORMIXSERVER - is the main name of the instance
2- INFORMIXDIR - product installation dir
3- ONCONFIG - name of the configuration file (located in
$INFORMIXDIR/etc/ the default is $INFORMIXDIR/etc/onconfig.std)
4- INFORMIXSQLHOSTS - the sqlhosts file (default if
$INFORMIXDIR/etc/sqlhosts)

You'll have to look in the $INFORMIXDIR/etc/$ONCONFIG for the lines with
SERVERNAME and DBSERVERALIAS.

The value in front of SERVERNAME is the main instance name.
The names in DBSERVERALIAS are alternatives name for the instance.
This names are mapped in the $INFORMIXSQLHOSTS file to protocols and
port names/numbers. Example:

main_instance_name onsoctcp myhost 1526

This would mean that the instance has a listening port on host "myhost"
at port 1526. You may have have other protocols beside TCP. One of them
is shared memory which means that only local clients can connect.
In this case you won't be able to connect via ODBC from a remote client.


Besides all this, if you only have one instance, and assuming it's
running Informix version 7 you can look at the oninit proceses... You'll
see one which is the parent of them all. With a tool called "lsof" you
can see which file descriptors it's using. In this list you'll see the
TCP port numbers.

Regards/Cumprimentos.

Fernando Nunes