IBM 000-8697 Set Your Environment Variables SQLEXEC, TBCONFIG

Installation and Initial Configuration 1-55
Set Your Environment Variables
SQLEXEC
The value ofSQLEXEC directs the front-end processes to a specific database
serverwithin the $INFORMIXDIR directory.The default value for SQLEXEC is
$INFORMIXDIR/lib/sqlturbo, the OnLine database server. If OnLine is the
only database server in your$INFORMIXDIR directory, you do not need to
defineSQLEXEC.
Ifyou worked with an IBM Informix SE database server on this machine in the
past, you might have anSQLEXEC environment variable already set for use
withSE. If you are not planning to maintain the SE database server but intend
to run only OnLine on this machine, you might need to modifySQLEXEC to
ensure that it now reflects the OnLine database server.
Ifyou intend to maintain both an SE database server and an OnLine database
server on the same machine, ensure that all users have theirSQLEXEC
variable properly set. (The pathname of theSE database server is
$INFORMIXDIR/lib/sqlexec.)
Set theSQLEXEC environment variable as follows:
TBCONFIG
TheTBCONFIG environment variable performs two tasks:
■Directs thetbinit process to the OnLine configuration file that is to
be read for initialization values
■Directs the OnLine server process (sqlturbo) to the correct OnLine
shared-memory space
The TBCONFIG value is not a full pathname; therefore, all OnLine configu-
ration files must reside in the directory$INFORMIXDIR/etc.
C shell: setenv SQLEXEC sqlexec_value
Bourne shell: SQLEXEC=sqlexec_value
export SQLEXEC