Informix Dynamic Server 9.21

Installation

Informix DS 9.21.UC4-2

Reference system: SUSE Linux 8.1 Professional [Basel - privat]

1. Preparations

There must be a group and user "informix".

The Informix products must be installed in a specific order if you are installing client and server products in the same $INFORMIXDIR directory:

• SQL software
• Database server
• Client SDK

Read the Informix installation guide for further instructions.

2. Creation of the Informix directory

Observe the following guidelines:

• Use the same directory to install both Dynamic Server and any local client products
• The INFORMIXDIR should be /opt/informix (SISIS-default for Linux)
• Create the directory on a local drive
• Documentation can be found under /opt/informix/release/en_us/0333

Create the product directory $INFORMIXDIR:

# mkdir /opt/informix
# chown -R informix /opt/informix

Set $INFORMIXDIR and put $INFORMIXDIR/bin in the PATH:

# export INFORMIXDIR=/opt/informix
# PATH=$PATH:$INFORMIXDIR/bin

Create the following entry in /etc/services :

# vi /etc/services
sqlturbo 1526/tcp # Informix

3. Installation of the Informix-SQL package from CD-ROM

Insert the CD-ROM.

# mount /cdrom
# cd $INFORMIXDIR
# tar xvf /cdrom/sql.tar
...
Enter your serial number:
Enter your serial number KEY:
...
# cd

# eject

If only the runtime version is installed:

# mount /cdrom
# cd $INFORMIXDIR
# tar xvf /cdrom/sqlrt.tar
# cd
# eject

4. Installation of the Informix Dynamic Server package from CD-ROM

After inserting the CD-ROM:

# mount /cdrom
# cd /cdrom/IDS
# rpm -iv ids.rpm
IDS2000-9.21.UC4-1
Informix Dynamic Server 2000 Version 9.21.UC4
Copyright (C) 1986-2000 Informix Software, Inc.
Installation Script

Installation Script Requirements:
- A user "informix" and a group "informix" must be known to the system.
- The product source files must have been loaded by user informix.
- This installation procedure must be run by user informix.

This script will change the owner, group, and mode of many of the files of this package in this directory.

Press RETURN to continue, or the interrupt key (usually CTRL-C or DEL) to abort.
...
Enter your serial number (for example, INF#X999999)
Enter your serial number KEY (uppercase letters only)
...
Press RETURN to continue, or the interrupt key (usually CTRL-C or DEL) to abort.
...
Informix Product:       Informix Dynamic Server 2000
Installation Directory: /opt/informix

Performing root portion of installation of Informix Dynamic Server 2000...

...Linking /usr/lib/ismdd09a.so from lib/ismdd09a.so...
...Linking /usr/lib/iosm09a.so from lib/iosm09a.so...
...Linking /usr/lib/ipldd09a.so from lib/ipldd09a.so...
...Linking /var/lib/libpthread.so.0 from lib/libifxpthread.so...

Installation of Informix Dynamic Server 2000 complete.

# cd
# eject

5. Extraction of the Informix-Client Software package

Make sure that $INFORMIXDIR is set correctly!

# mount /cdrom
# cd /cdrom/ICONNECT/LINUX
# rpm -iv --replacefiles ICONNECT.RPM
iconn-2.40.UC1-1
...
Is I-Connect being installed along with Informix database server version 9.x?
yes
...
Press RETURN to continue.
...
Enter your serial number (for example, INF#X999999) >
Enter your serial number KEY (uppercase letters only) >
...
Press RETURN to continue.
Installing directory gls/lc11/sv_se
Installing directory gls/lc11/th_th
Installing directory gls/lc11/zh_cn
Installing directory gls/lc11/zh_tw

Informix Product: INFORMIX-Connect
Installation Directory: /opt/informix

Performing root portion of installation of INFORMIX-Connect...

Installation of INFORMIX-Connect complete.

# cd
# eject

6. Configuration of the database server

Next is the configuration of the Dynamic Server. First the disk spaces for the needed dbspaces have to be allocated.

Note: The physdbs and the datadbs (sikisdbs, siasdbs, sieradbs) should not reside on the same disk. So place the datadbs and tempdbs on the system disk but rootdbs, physdbs and logdbs on the second disk. If more disks are available, then divide the dbspaces more. Raw-devices are not supported!

Edit the file .profile of the user "informix":

# vi /home/informix/.profile
export INFORMIXDIR=/opt/informix
PATH=$PATH:$INFORMIXDIR/bin
export INFORMIXSERVER=sisis
export ONCONFIG=onconfig.sisis

The directory /DBinformix,where the cooked space will reside as user "informix", already exists:

# chown informix:informix /DBinformix
# su - informix

$ cd /DBinformix
$ cat /dev/null > rootdbs
$ cat /dev/null > sisisdbs
$ cat /dev/null > tempdbs

If necessary, also create the following dbspaces:

$ cat /dev/null > physdbs
$ cat /dev/null > logdbs
$ cat /dev/null > sikisdbs
$ cat /dev/null > siasdbs
$ cat /dev/null > sieradbs

$ chmod 660 *dbs
                                                    
$ cd /home/informix
$ mkdir links
$ cd links
$ ln -s /DBinformix/rootdbs rootdbs
$ ln -s /DBinformix/sisisdbs sisisdbs
$ ln -s /DBinformix/tempdbs tempdbs

If necessary, also link the following dbspaces:

$ ln -s /DBinformix/physdbs physdbs
$ ln -s /DBinformix/logdbs logdbs
$ ln -s /DBinformix/sikisdbs sikisdbs
$ ln -s /DBinformix/siasdbs siasdbs
$ ln -s /DBinformix/sieradbs sieradbs

The file $INFORMIXDIR/etc/sqlhosts must have the following syntax:

<database servername> <protocol> <hostname> <service>

In our example the file /opt/informix/etc/sqlhosts has the following entries:

sisis onipcshm sh-dz sisis_shm
sisis_tcp onsoctcp sh-dz sqlturbo

The next step is to create the file $INFORMIXDIR/etc/onconfig.sisis :

$ cd /opt/informix/etc
$ cp onconfig.std onconfig.sisis

It is strongly recommended to alter the following parameters to the given values (according to our example):

ROOTPATH        /home/informix/links/rootdbs    # Device containing root dbspace
ROOTSIZE        200000                          # Size of root dbspace (Kbytes)
PHYSFILE        3000                            # Physical log file size (Kbytes)
LOGFILES        10                              # Number of logical log files
LOGSIZE         10000                           # Logical log size (Kbytes)
MSGPATH         /opt/informix/etc/online.log    # System message log file path
ALARMPROGRAM    /opt/informix/etc/log_full.sh   # Alarm program path
# TAPEDEV       /dev/null                       # Tape device path
# TAPEDEV       /dev/rmt0
TAPEDEV         /home/informix/sicherung.sisis/level0
TAPESIZE        4000000                         # Mamximum amount of data to put on tape (Kbytes)
# LTAPEDEV      /dev/null                       # Log tape device path
LTAPEDEV        /home/informix/sicherung.sisis/logfiles/logfile
SERVERNUM       1                               # Unique id corresponding to a OnLine instance
DBSERVERNAME    sisis                           # Name of default database server
DBSERVERALIASES sisis_tcp                       # List of alternate dbservernames
NETTYPE         ipcshm,1,50,CPU                 # Configure poll thread(s) for nettype
NETTYPE         soctcp,1,50,NET                 # Configure poll thread(s) for nettype
NOAGE           1                               # Process aging
LOCKS           20000                           # Maximum number of locks
BUFFERS         2000                            # Maximum number of shared buffers
NUMAIOVPS       1                               # Number of IO vps
PYSBUFF         16                              # Physical log buffer size (Kbytes)
LOGSBUFF        16                              # Logical log buffer size (Kbytes)
LOGSMAX         10                              # Maximum number of logical log files
CLEANERS	 5                               # Number of buffer cleaner processes
SHMVIRTSIZE	 128000                          # initial virtual shared memory segment
LRUS            4                               # Number of LRU queues
LRU_MAX_DIRTY	 1                               # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY	 0                               # LRU percent dirty end cleaning limit
DRLOSTFOUND	 /opt/informix/etc/dr.lostfound  # DR lost+found path
RA_PAGES	 40                              # Number of pages to attempt to read ahead
RA_THRESHOLD	 30                              # Number of pages left before next group
SYSALARMPROGRAM /opt/informix/etc/evidence.sh   # System alarm program
JVPJAVAHOME     /opt/informix/extend/krakatoa/jre/        # JRE installation root
JVPHOME         /opt/informix/extend/krakatoa/            # Krakatoa installation root
JVPPROPFILE     /opt/informix/extend/krakatoa/.jvpprops   # JVP property file
JVPLOGFILE      /opt/informix/jvp.log                     # JVP log file
# JVPCLASSPATH  /opt/informix/extend/krakatoa/krakatoa.jar:/opt/informix/extend/krakatoa/jdbc.jar
JVPCLASSPATH    /opt/informix/extend/krakatoa/krakatoa_g.jar:/opt/informix/extend/krakatoa/jdbc_g.jar

Now create the tape device path and also the log tape device path:

$ cd /home/informix
$ mkdir sicherung.sisis
$ chmod 775 sicherung.sisis
$ cd sicherung.sisis
$ cat /dev/null > level0
$ chmod 666 level0
$ mkdir logfiles
$ chmod 775 logfiles

Now initialize the server "sisis".

$ oninit -i
This command initializes the Informix Dynamic Server 2000; any existing Informix Dynamic Server 2000 databases 
  will NOT be accessible - Do you wish to continue (y/n)? y

Don't get nervous - this may take some minutes!

Note: Check the file online.log for the entries:

'sysmaster' database built successfully.
'sysutils' database built successfully.

Monitor the operation of the database server, showing the dbspaces and chunks.

$ onstat -d
Informix Dynamic Server 2000 Version 9.21.UC4  -- On-Line -- Up 00:12:18 -- 41312 Kbytes

Dbspaces
address  number   flags    fchunk     nchunks  flags    owner    name
10a277d0 1        0x1        1        1        N        informix rootdbs
 1 active, 2047 maximum

Chunks
address  chk/dbs offset  size    free    bpages   flags pathname
10a27918 1   1   0       100000  91732            PO-   /home/informix/links/rootdbs
 1 active, 2047 maximum

Create the the dbspace "sisisdbs":

$ onspaces -c -d sisisdbs -p /home/informix/links/sisisdbs -o 0 -s 2000000

If necessary, also create the following dbspaces:

$ onspaces -c -d sisisdbs -p /home/informix/links/logdbs -o 0 -s <size in pages>
$ onspaces -c -d sisisdbs -p /home/informix/links/physdbs -o 0 -s <size in pages>
$ onspaces -c -d sisisdbs -p /home/informix/links/siasdbs -o 0 -s <size in pages>
$ onspaces -c -d sisisdbs -p /home/informix/links/sieradbs -o 0 -s <size in pages>
$ onspaces -c -d sisisdbs -p /home/informix/links/sikisdbs -o 0 -s <size in pages>

Finally create the dbspace "tempdbs" with these options:

$ onspaces -c -t -d tempdbs -p /home/informix/links/tempdbs -o 0 -s 1000000

After this change the variable DBSPACETEMP in the file $INFORMIXDIR/etc/onconfig.sisis (this can only be done now!):

$ vi /opt/informix/etc/onconfig.sisis
DBSPACETEMP	/home/informix/links/tempdbs     # Default temp dbspaces

At last perform a level0 archive (the archive will be created at $TAPEDEV/level0 ):

$ ontape -s -L 0