Filter
Top Products
Installation and Initial Configuration 1-55
Set Your Environment Variables
SQLEXEC
The value of SQLEXEC directs the front-end processes to a specific database
server within 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
define SQLEXEC.
If you worked with an
IBM Informix SE database server on this machine in the
past, you might have an SQLEXEC environment variable already set for use
with SE. If you are not planning to maintain the SE database server but intend
to run only OnLine on this machine, you might need to modify SQLEXEC to
ensure that it now reflects the OnLine database server.
If you intend to maintain both an SE database server and an OnLine database
server on the same machine, ensure that all users have their SQLEXEC
variable properly set. (The pathname of the SE database server is
$INFORMIXDIR/lib/sqlexec.)
Set the SQLEXEC environment variable as follows:
TBCONFIG
The TBCONFIG environment variable performs two tasks:
■ Directs the tbinit 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