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