Identify the Informix tcp port number

Unix Database Servers

  1. Log in to your Unix database server as the Informix user.
  2. Ensure that the Informix environment has been correctly set.
  3. Execute this command:


    echo $INFORMIXSERVER

  4. Execute this command:


    more $INFORMIXDIR/etc/sqlhosts

  5. Look for the line that begins with your $INFORMIXSERVER value, and note the value that appears in the fourth column. This is your service name.
  6. Execute this command:


    more /etc/services

  7. Search the output for the line that beings with the service name you found in $INFORMIXDIR/etc/sqlhosts. Note the associated port number.

Windows Database Servers

  1. Log in to your Windows database server.
  2. Open an MS-DOS command prompt.
  3. Run this command:


    regedit

  4. Drill down to


    HKEY_LOCAL_MACHINE\ SOFTWARE\ INFORMIX\ SQLHOSTS

  5. Look for the value passed to Service.
  6. Exit the Registry.
  7. Use Notepad to open the C:\Windows\System32\Drivers\etc\services or C:\WINNT\System32\Drivers\etc\services file.
  8. Look for the port number that corresponds to the service in the registry.