Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

How Do I Interpret 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. Multi-Tier users need to insure that pertinent database .profile variables appear in the [Environment] section of their Session Rules Books. The Session Rules Book 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
Single-Tier users needs to insure that the same variables appear in the [Environment] section of their openlink.ini file. The openlink.ini file appears in the /bin sub-directory of the Single-Tier 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.