How to install InformixSE on Caldera Open Linux 1.2 Lite
Install the package as user root:
> Create group informix (/etc/group)
> Create user informix with group informix (/etc/passwd)
> unzip INFORMIXSE distribution into a temporary staging directory
like /tmp/stage.
unzip 730uc5op.zip
> Create the INFORMIXDIR where the code is installed:
mkdir /opt/informix_se
chown informix /opt/informix_se
chgrp informix /opt/informix_se
chmod u+w,ugo+rx /opt/informix_se
export INFORMIXDIR=/opt/informix_se
cd $INFORMIXDIR
> Informix products must be installed by root in the
correct order, follow the prompts for serial# and key.
Embedded SQL C product, ESQL
Informix Standard Engine, SE
Informix Connect, ICONNECT
tar xvf //LINUX_se_bundle724UC5/ESQLC/ESQL.TAR
./installesql
tar xvf //LINUX_se_bundle724UC5/SE/SE.TAR
./installse
tar xvf //LINUX_se_bundle724UC5/ICONNECT/CONNECT.TAR
./installconnect
> For Caldera, TCP communication for the server is
used rather than the IPC defaults. Set up database
server communication uses /etc/hosts,
/etc/services, $INFORMIXDIR/sqlhosts, and $INFORMIXDIR/lib/sqlexecd.
> Example /etc/hosts entry used:
# The format is:
# ipaddr fully_qualified_hostname list_of_nicknames
127.0.0.1 bitchkrieg.umn.edu bitchkrieg localhost
> Add the following entry to /etc/services
sqlexec 1526/tcp # Informix SE
> Save the original $INFORMIXDIR/etc/sqlhosts file.
cp $INFORMIXDIR/etc/sqlhosts $INFORMIXDIR/etc/sqlhosts.original
> Change the default demo_se entry in $INFORMIXDIR/etc/sqlhosts
to look similar to the following.
# Field description of sqlhosts file and/or system file
# related to each field.
# servername tcp /etc/hosts /etc/services name
demo_se sesoctcp localhost sqlexec
># Start the sqlexecd to enable tcp communication to
# the Informix database server. You may want to run this
# at boot time using /etc/rc files.
# demo_se in the sqlexecd command is the first field
# in the sqlhosts file.
$INFORMIXDIR/lib/sqlexecd demo_se -l /var/log/sqlexecd.log
##############################################################
The above was done by root, now set up a database using the
demo package that came with Informix. My recommendation
is that a user owns the database that is not user root or informix.
For this example the user is 'feklar'.
I also recommend keeping the database files separate from
the package installation directory tree so that in the
future it is easier to change to another code release.
The database will be set up under the home of user
feklar in a subdirectory.
> Set up user environment. Log in as user 'feklar'.
example is using bash,sh,ksh type shell.
INFORMIXDIR=/opt/informix_se; export INFORMIXDIR
PATH=$PATH:$INFORMIXDIR/bin; export PATH
INFORMIXSERVER=demo_se; export INFORMIXSERVER
> Run the dbaccess interpreter demo7 application.
mkdir informix_demo7
cd informix_demo7
$INFORMIXDIR/bin/dbaccessdemo7
> The stores7.dbs file is the data file. All other files are
SQL scripts that can be run using the dbaccess interpreter.