Identify the Informix database server hostname or IP address

Unix Database Servers

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


    echo $INFORMIXSERVER

  4. Execute this command:


    cat $INFORMIXDIR/etc/sqlhosts

  5. Look for the line that begins with the $INFORMIXSERVER value, and note the value that appears in the third column. This is the hostname that your Informix server was initialized with at startup time.

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 HOST. This is the hostname that your Informix server was initialized with at startup time.

Referenced by...