Technical article 127003

How can I install a legacy OpenServer 5 Informix Database on my OpenServer 6.0.0 system?

OpenServer 6.0.0

Written · Last revised

Problem

How can I install a legacy OpenServer 5 Informix Database on my OpenServer 6.0.0 system?

Solution

It is possible to install, configure and run a legacy Informix Database on OpenServer 6.0.0 if you have Maintenance Pack 3 or later installed.

This article describes the steps needed to install
Informix IDS 7.31 UC5 for OpenServer 5.0

but these steps can be adapted to install other Informix databases.

Installation of Informix IDS 7.3 can be broken into 3 phases:

1) Configuration of OpenServer 6.0.0 prior to installation of the Informix Database 2) Installation of the Informix Database 3) Configuration of the Informix Database 4) Initializing the Informix Database 5) Testing access to your Informix Database

The steps for each phase are described below:

1) Configuration of OpenServer 6.0.0 prior to the installation of the Informix Database.

Before you install the Informix database on your OpenServer 6.0.0 server you must:

- Install Maintenance Pack 3 or later onto your server. You can download the latest Maintenance Pack for OpenServer 6.0.0 from:

http://www.sco.com/support/update/download/product.php?pfid=12&prid=20
- Log into the server as root

- Using the SCOadmin Account Manager, create a new group called informix with an id greater than or equalt to 100

- Using the SCOadmin Account Manager, create a new user called informix and make the group informix the login group of the informix user

- Edit the root user account /.profile and add the following:

INFORMIXDIR=/u/informix
export INFORMIXDIR
PATH=$PATH:$INFORMIXDIR/bin
export PATH
ONCONFIG=onconfig.std
export ONCONFIG
INFORMIXSERVER=scodb1
export INFORMIXSERVER

- Edit the informix user account .profile (/u/informix/.profile) and add:

INFORMIXDIR=/u/informix
export INFORMIXDIR
PATH=$PATH:$INFORMIXDIR/bin
export PATH
ONCONFIG=onconfig.std
export ONCONFIG
INFORMIXSERVER=scodb1
export INFORMIXSERVER

These environment variables tell the Informix installation scripts and utilities:

- where Informix is to be installed (ie /u/informix) - where to find Informix binaries (ie /u/informix/bin) - what the name of the Informix configuration file will be (ie onconfig) - what the name of the database server will be (ie scodb1)

You are now ready to install the database.

2) Installing the Informix Database

In this section we will describe how to install the Informix IDS 7.3 database. If you have additional Informix products that you wish to install (e.g. an Informix 4GL Runtime or other complimentary product) then these should be installed before the Informix Dabatase.

Installation of such products is beyond the scope of this article. Please refer to your Informix product documentation for steps on installing your additional products prior to the installation of the Informix IDS 7.3 database.

- Login to the OpenServer 6.0.0 server as root

- Change to the informix directory using:

# cd $INFORMIXDIR

- Informix IDS 7.3 is distributed as a cpio(C) archive. You will need to copy the cpio archive from your Informix Distribution media into the $INFORMIXDIR directory. e.g. Lets assume the cpio archive is called

informix_ids.cpio

and its currently in /tmp on your server. To copy it run:

# cp /tmp/informix_ids.cpio $INFORMIXDIR

- Extract the cpio archive as follows:

# cpio -icvd -I informix_ids.cpio

- Install the Informix IDS server using the "installserver" script as follows:

# ./installserver

This script will prompt you for your Serial Number and Key, it will install and set the correct permissions on files and directories and on successful completion will issue the message:

Installation of Informix Dynamic Server complete.

Your Informix server is installed and now needs to be configured.

3) Configuring your Informix Server

Once your have successfully installed your Informix database you will still need to configure it. To configure the database do the following:

- Log into the OpenServer 6.0.0 system as root

- Add the following entry for Informix to the /etc/services (services(SFF)) file using your favourite editor:

kifos        1801/tcp

- Edit the Informix sqlhosts file ($INFORMIXDIR/etc/sqlhosts) file and add the entries:

scodb1     ontlitcp        scopaddy     	kifos
scodb1_shm onipcshm        scopaddy       srv_agent

where scopaddy should be replaced by the hostname of your OpenServer 6.0.0 server.

- Create the Informix Root Database using:

# mkdir /usr1
# touch /usr1/rootdbs
# chmod 0666 /usr1/rootdbs
# chown informix:informix /usr1/rootdbs
NOTE:    We have chosen to create the database in /usr1 but you can
         choose any location for the database once you make the correct
         changes to the configuration below.

- Using your favourite editor make the following changes to the Informix Database Configuration File, $INFORMIXDIR/etc/onconfig.std :

ROOTPATH      /usr1/rootdbs
ROOTSIZE      102400
PHYSFILE      5000
MSGPATH               /u/informix/online.log
ALARMPROGRAM  /u/informix/etc/log_full.sh
SYSALARMPROGRAM       /u/informix/etc/evidence.sh
SERVERNUM     1
DBSERVERNAME  scodb1
DBSERVERALIASES       scodb1_shm
NETTYPE               ipcshm,1,100,CPU
LOCKS         10000
BUFFERS               20000
SHMBASE               0x82000000L
DRLOSTFOUND   /u/informix/etc/dr.lostfound
BAR_BSALIB_PATH               /u/informix/lib/libbsa.so
NOTE:    You may wish to modify some of the parameters such as ROOTSIZE,
         PHYSFILE, LOCKS and BUFFERS to meet your own requirements.

- Create a symbolic link for one of the Informix libraries using:

# ln -s /u/informix/lib/libbsa.so /u/informix/lib/ibsad001.so
- Copy sm_versions.std to sm_versions using:
cp $INFORMIXDIR/etc/sm_versions.std $INFORMIXDIR/etc/sm_versions
Configuration is now complete.
4) Initialising the Informix Database

Once configuration is complete you can initialise the Informix Database as follows:

- Log into the Openserver 6.0.0 server as the informix user

- Run the command:
$ oninit -iy

Your Informix Dabatase is now initialised and ready to use.

5) Testing access to the Informix Database

You can verify that you can access your Informix database using the dbaccess command as follows:

- Log into the Openserver 6.0.0 server as informix

- Run the command:
$ dbaccess
From the menu select "Connection" and then "Connect". If your
database is configured then you will be prompted to
SELECT DATABASE SERVER>> and will be offered two choices:
scodb1
and
scodb1_shm

See also

TA#127096 "UX:ld: ERROR: lib4gl.a(fglesql.o): cannot link OpenServer object into Intel iABI (UDK ABI) target" TA#127097 "UX:ld: ERROR: cannot open file /u/informix/lib/tools/nettlistub.a for reading: No such file or directory" TA#127098 "I get UX:ld: ERROR: library not found: -lnsl_s when compiling my Informix application on OpenServer 6.0.0" TA#127099 "I get "internal conversion of COFF file to ELF" messages when compiling my Informix 4GL application on OpenServer 6.0.0" TA#127100 "How can I install the INFORMIX-4GL Version 7.20.UE2 on my OpenServer 6.0.0 system?

From the Xinuos technical article database, record 127003. Reproduced with permission. The original is at www.sco.com/ta/127003, which is reachable but blocked from search engines.

Next step

Need this fixed rather than explained?

Tell us the release, what the system runs and what it is doing. We will reply by email with what we would do next.

  • You deal with the people who do the work
  • No obligation, and no upgrade required before we will help
  • We tell you plainly if something is not worth doing

Send an enquiry

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.