Finding the Informix Dynamic Server Port Number on Linux
Web Doc
Note: This is publication is now archived. For reference only.
Abstract
This tip provides information to help determine the Linux port number to use for Informix Dynamic Server when integrating with WebSphere.
Contents
For a Java developer using WebSphere Studio Application Developer, one of the most important things to know is how to connect to the database server that interacts with the application. Typically, you should contact the database administrator and get all the necessary information, such as:
2. IDS server (instance) name
3. Database name
4. TCP/IP port number
5. User name and password with the necessary privileges
# vi $INFORMIXSQLHOSTS
If INFORMIXSQLHOSTS is not configured the server uses the default file, so open it up using vi:
# vi $INFORMIXDIR/etc/sqlhosts
3. Locate the correspondent entry of the instance name. The instance name is stored in the first column of the entry and the service name (port number) is stored on the forth column. In this case we have demo_on as the server name and demo_on_tcp as the service name.
# vi /etc/services
5. Search for service demo_on_tcp in the /etc/services file and find the port number. In our case the port 1533 is assigned to demo_on_tcp. Here are the port number and service name that have to be used in your application.
1. Host name
2. IDS server (instance) name
3. Database name
4. TCP/IP port number
5. User name and password with the necessary privileges
Most of this information has to be given by the database administrator, but you may be able to find some of the information yourself. In this section we show how to find the port number configured for an IDS server instance.
Steps to find the port number
1. Log into the Linux server with the user ID that was given by the database administrator (in our case, itso).
2. Open the sqlhosts file. You have to know the location of this file since it can be in any directory, using the INFORMIXSQLHOSTS environment variable. You must ask your database administrator if this variable is set. If so, get the value stored and open the file:
# vi $INFORMIXSQLHOSTS
If INFORMIXSQLHOSTS is not configured the server uses the default file, so open it up using vi:
# vi $INFORMIXDIR/etc/sqlhosts
3. Locate the correspondent entry of the instance name. The instance name is stored in the first column of the entry and the service name (port number) is stored on the forth column. In this case we have demo_on as the server name and demo_on_tcp as the service name.
4. Now that we know the service name we need to find out the TCP/IP port assigned to it. To do that open the /etc/services file.
# vi /etc/services
5. Search for service demo_on_tcp in the /etc/services file and find the port number. In our case the port 1533 is assigned to demo_on_tcp. Here are the port number and service name that have to be used in your application.
Special Notices
The material included in this document is in DRAFT form and is provided 'as is' without warranty of any kind. IBM is not responsible for the accuracy or completeness of the material, and may update the document at any time. The final, published document may not include any, or all, of the material included herein. Client assumes all risks associated with Client's use of this document.