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 OpenLink server components installation. For example:

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.