Identify the Informix tcp service name

Unix Database Servers

  1. Login to your Unix database server as the Informix user.
  2. Ensure the Informix environment is properly set.
  3. Execute this command:


    echo $INFORMIXSERVER

  4. Execute this command:


    more $INFORMIXDIR/etc/sqlhosts

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

Windows Database Servers

  1. Login 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. This is your service name.