Informix Port Number

Posted in 1999

Summary

User asked how to find the port number Informix Dynamic Server listens on for JDBC connections on SunOS. Responses suggested using netstat, checking ONCONFIG file and sqlhosts, and examining /etc/services. A clarification noted Informix doesn't automatically modify /etc/services on Unix. The most practical solution offered was running 'onstat -g ntt' to directly display the port number.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Java & JDBC Development

Katak — Wed, 17 Mar 1999 13:50:20 +0800 — source: Informix-list mailing list archive (1991-1998)

Hi there, Anyone out there knows how to check the port number that the Informix Dynamic Server is listening at. As I am currently trying to connect to the database using JDBC drivers from Informix. By the way, what is default port number that the Dynamic Server is listening at. It is installed in a UNIX box with SUN OS5.6

↪ replying to Katak

Jonathan Leffler — Tue, 16 Mar 1999 23:23:01 -0800 — source: Informix-list mailing list archive (1991-1998)

Katak wrote: > Anyone out there knows how to check the port number that the Informix > Dynamic Server is listening at. As I am currently trying to connect to > the database using JDBC drivers from Informix. By the way, what is > default port number that the Dynamic Server is listening at. It is > installed in a UNIX box with SUN OS5.6 Probably the best way is with netstat(1) or an equivalent command. Alternatively, you poke through the ONCONFIG file and find the DBSERVERNAME and DBSERVERALIASES fields. Then you study the sqlhosts file to establish which services are in use, and then you study the services file to see which ports these are on. Of course, using YP (NIS or NIS+) complicates the issue. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>

↪ replying to Jonathan Leffler

Frank Boehm — Wed, 17 Mar 1999 09:54:26 +0100 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote: > Katak wrote: > > Anyone out there knows how to check the port number that the Informix > > Dynamic Server is listening at. As I am currently trying to connect to > > the database using JDBC drivers from Informix. By the way, what is > > default port number that the Dynamic Server is listening at. It is > > installed in a UNIX box with SUN OS5.6 > > Probably the best way is with netstat(1) or an equivalent command. > Alternatively, you poke through the ONCONFIG file and find the > DBSERVERNAME and DBSERVERALIASES fields. Then you study the sqlhosts > file to establish which services are in use, and then you study the > services file to see which ports these are on. Of course, using > YP (NIS or NIS+) complicates the issue. you may want to take a look into /etc/services; ifmx adds 2 port numbers during the installation, (something 205x) bye frank

↪ replying to Frank Boehm

Art S. Kagel — Wed, 17 Mar 1999 11:42:26 -0500 — source: Informix-list mailing list archive (1991-1998)

Frank Boehm wrote: > > Jonathan Leffler wrote: > > > Katak wrote: > > > Anyone out there knows how to check the port number that the Informix > > > Dynamic Server is listening at. As I am currently trying to connect to > > > the database using JDBC drivers from Informix. By the way, what is > > > default port number that the Dynamic Server is listening at. It is > > > installed in a UNIX box with SUN OS5.6 > > > > Probably the best way is with netstat(1) or an equivalent command. > > Alternatively, you poke through the ONCONFIG file and find the > > DBSERVERNAME and DBSERVERALIASES fields. Then you study the sqlhosts > > file to establish which services are in use, and then you study the > > services file to see which ports these are on. Of course, using > > YP (NIS or NIS+) complicates the issue. > > you may want to take a look into /etc/services; ifmx adds 2 port numbers > during the installation, (something 205x) Ummm... The Informix installation does not touch /etc/services you will have had to have edited it manually to add any services you want. Art S. Kagel

↪ replying to Art S. Kagel

David Kosenko — Wed, 17 Mar 1999 21:23:12 GMT — source: Informix-list mailing list archive (1991-1998)

On Wed, 17 Mar 1999 11:42:26 -0500, "Art S. Kagel" <kagel@bloomberg.net> wrote: >Frank Boehm wrote: >> you may want to take a look into /etc/services; ifmx adds 2 port numbers >> during the installation, (something 205x) > >Ummm... The Informix installation does not touch /etc/services you will >have had to have edited it manually to add any services you want. Frank may be working on NT, where the install process will make entries in the services file for you. It is Unix installs that require manual modification of the services file. Dave

↪ replying to David Kosenko

Joe Lumbley — Thu, 18 Mar 1999 17:01:20 GMT — source: Informix-list mailing list archive (1991-1998)

A good all-informix way to do this is with onstat -g ntt. Near the bottom will be a line that includes two UNIX pipe (|) symbols. The port number is between the two pipes. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" The DBA Survival Guide, Second Edition will cover NT, 7.X through 7.3, graphical utilities, more survival hints. Publish date: 12/16/98 FINALLY! ---------------------------------------------------------------------------