Code Samples   Home

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.