Identify the Informix startup mode (i.e., sockets or shared memory)




Unix Database Servers

  1. Log in to your Unix database server as the Informix user.
  2. Set the Informix environment, if not automatically set by the login.
  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 second column.
    • If this value is onsoctcp, ontlitcp, or anything else containing tcp, this $INFORMIXSERVER will accept sockets-based connections.
    • If this value is onipcshm, or anything else containing shm, this $INFORMIXSERVER will not accept sockets-based connections; it will only accept shared-memory connections.

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 PROTOCOL.
    • If this value is onsoctcp, ontlitcp, or anything else containing tcp, this $INFORMIXSERVER will accept sockets-based connections.
    • If this value is onipcshm, or anything else containing shm, this $INFORMIXSERVER will not accept sockets-based connections; it will only accept shared-memory connections.

Ramifications