%META:TOPICPARENT{name="TroubleshootingUDAUsingEvidence"}%
===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 <nop>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.