Database .profiles
Database .profiles are Unix files that contain variables that databases need to function. They appear in the root directory of most database installations. Furthermore, these environment variables facilitate ODBC, JDBC, and other data access mechanisms.
If you are using Multi-Tier drivers, you need to insure that the pertinent database .profile variables appear in the [Environment] section of your Session Rulebook.
The Session Rulebook is the oplrqb.ini file that resides in the /bin sub-directory of the
Informix database .profile
INFORMIXDIR=/dbs/informix/32bit/IDS2000 INFORMIXSERVER=hp2server ONCONFIG=onconfig PATH=$PATH:$INFORMIXDIR/bin SHLIB_PATH=$SHLIB_PATH:$INFORMIXDIR/lib export INFORMIXDIR PATH SHLIB_PATH INFORMIXSERVER ONCONFIG
Multi-Tier Session Rules Book
[Environment INFORMIX2000] INFORMIXSERVER = hp2server INFORMIXDIR = /dbs/informix/32bit/IDS2000 DELIMIDENT = Y OPL_INF_MULTISESS = Y OPL_SPACEPADCHAR = Y CURSOR_SENSITIVITY = LOW ;FET_BUF_SIZE = 65535 ;FORCE_ONLINE_DATABASE = 1 ;LD_LIBRARY_PATH = /dbs/informix2000/lib ;SHLIB_PATH = /dbs/informix2000/lib ;LIBPATH = /dbs/informix2000/lib ;CLIENT_LOCALE = EN_US.UTF8
If you are using Lite Edition drivers, you need to insure that the same variables appear in the [Environment] section of your openlink.ini file.
The openlink.ini file appears in the /bin sub-directory of the Lite Edition client installation.
Its [Environment] sections are similar to the [Environment] sections in the Multi-Tier oplrqb.ini file.
Finally, suspect environment variable problems when server handle errors, permissions errors, or blatant environment variable errors occur.