Re: Which port is Informix listening?
- From: Fernando Nunes <spam@xxxxxxxxxxxxxxx>
- Date: Mon, 31 Oct 2005 10:34:09 +0000
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 .
- References:
- Which port is Informix listening?
- From: Nuno Paquete
- Which port is Informix listening?
- Prev by Date: myschema/myexport for hp-ux 10.20, IDS 7.31
- Next by Date: Re: ER problem---CDRACK cause rootserver crash
- Previous by thread: Re: Which port is Informix listening?
- Next by thread: Informix User Forum 2005 - Moving Forward With Informix -December 8-9 in Atlanta, GA
- Index(es):
Relevant Pages
|
|
