Identify the Informix instance name

Unix Database Servers

1. Login to your Unix database server.

2. su to your Informix user.

3. Execute the .profile associated with your Informix user.

4. Execute this command: echo $INFORMIXSERVER

This should be your Informix instance name. It can be verified by opening the $INFORMIXDIR/etc/sqlhost file. There should be an entry in the file that starts with the same $INFORMIXSERVER value.

Windows Database Servers

1. Login to your Windows database server.

2. Open an MS-DOS command prompt.

3. Run this command: regedit

4. Expand this tree structure: HKEY_LOCAL_MACHINE\SOFTWARE\INFORMIX\SQLHOSTS

There should be one or more sub-folders. Each sub-folder represents an Informix instance.