Re: Which port is Informix listening?

Hi, the listener is using port 49213 (assuming that that number is the actual port number - usually I use "netstat -n" or "netstat -an" to figure this out as I'm sure that I really see the port number in that netstat output). [ This line of your netstat output has the "LISTEN" indicator and it does not have a foreign address (only *.*). This indicates that this port is used by a listener process and it is doing just that, listening for connection requests. As there is no active connection, but only the listening, there is no foreign address given. The other output line with 32768 as local address shows an active connection, which in this case is a process on the same machine connected. Therefore you see this address again with the port number in the foreign address. If someone was connected from a different machine, you'd see only one line for the connection, but you'd see the foreign address (like in the first line of your output). ] Of course there can be more than one listener process on a machine, not just from IDS, but from other software also (like some daemon program waiting for connections). So actually the correct way to figure out the particular port number for a listener of IDS is to work it out from the sqlhosts file of the particular server and using the corresponding entry in /etc/services if necessary. I use "netstat -an" only to verify, that a running IDS is using a particular port number, or to verify that a port number to be used by IDS is used by some other process (while IDS is not running). Unfortunately on most UNIX systems it is not possible (or at least quite complicated) to find out which process is using a particular port. Certainly it is not possible from the netstat output alone. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 30.10.2005 12:35:14: > 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 sending to informix-list