Quelltext der Seite Informix Dynamic Server 9.21

== Installation ==

Informix DS 9.21.UC4-2

<b>Reference system:</b> 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<tt> INFORMIXDIR </tt>should be<tt> /opt/informix </tt>(SISIS-default for Linux)
* Create the directory on a local drive
* Documentation can be found under<tt> /opt/informix/release/en_us/0333 </tt>

Create the product directory<tt> $INFORMIXDIR</tt>:
 # <b>mkdir /opt/informix</b>
 # <b>chown -R informix /opt/informix</b>

Set<tt> $INFORMIXDIR </tt>and put<tt> $INFORMIXDIR/bin </tt>in the<tt> PATH</tt>:
 # <b>export INFORMIXDIR=/opt/informix</b>
 # <b>PATH=$PATH:$INFORMIXDIR/bin</b></tt>

Create the following entry in<tt> /etc/services </tt>:
 # <b>vi /etc/services</b>
 sqlturbo 1526/tcp # Informix

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

Insert the CD-ROM.
 # <b>mount /cdrom</b>
 # <b>cd $INFORMIXDIR</b>
 # <b>tar xvf /cdrom/sql.tar</b>
 ...
 Enter your serial number:
 Enter your serial number KEY:
 ...
 # <b>cd</b><br>
 # <b>eject</b></tt></p>

If only the runtime version is installed:
 # <b>mount /cdrom</b>
 # <b>cd $INFORMIXDIR</b>
 # <b>tar xvf /cdrom/sqlrt.tar</b>
 # <b>cd</b>
 # <b>eject</b>

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

After inserting the CD-ROM:
 # <b>mount /cdrom</b>
 # <b>cd /cdrom/IDS</b>
 # <b>rpm -iv ids.rpm</b>
 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.
 
 # <b>cd</b>
 # <b>eject</b>

=== 5. Extraction of the Informix-Client Software package ===

Make sure that<tt> $INFORMIXDIR </tt>is set correctly!
 # <b>mount /cdrom</b>
 # <b>cd /cdrom/ICONNECT/LINUX</b>
 # <b>rpm -iv --replacefiles ICONNECT.RPM</b>
 iconn-2.40.UC1-1
 ...
 Is I-Connect being installed along with Informix database server version 9.x?
 <b>yes</b>
 ...
 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.
 
 # <b>cd</b>
 # <b>eject</b></tt>

=== 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.

<b>Note:</b> 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<tt> .profile </tt>of the user "informix":
 # <b>vi /home/informix/.profile</b>
 export INFORMIXDIR=/opt/informix
 PATH=$PATH:$INFORMIXDIR/bin
 export INFORMIXSERVER=sisis
 export ONCONFIG=onconfig.sisis

The directory<tt> /DBinformix</tt>,where the cooked space will reside as user "informix", already exists:
 # <b>chown informix:informix /DBinformix</b>
 # <b>su - informix</b>

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

If necessary, also create the following dbspaces:
 $ <b>cat /dev/null > physdbs</b>
 $ <b>cat /dev/null > logdbs</b>
 $ <b>cat /dev/null > sikisdbs</b>
 $ <b>cat /dev/null > siasdbs</b>
 $ <b>cat /dev/null > sieradbs</b>
 
 $ <b>chmod 660 *dbs</b>
                                                     
 $ <b>cd /home/informix</b>
 $ <b>mkdir links</b>
 $ <b>cd links</b>
 $ <b>ln -s /DBinformix/rootdbs rootdbs</b>
 $ <b>ln -s /DBinformix/sisisdbs sisisdbs</b>
 $ <b>ln -s /DBinformix/tempdbs tempdbs</b>

If necessary, also link the following dbspaces:
 $ <b>ln -s /DBinformix/physdbs physdbs</b>
 $ <b>ln -s /DBinformix/logdbs logdbs</b>
 $ <b>ln -s /DBinformix/sikisdbs sikisdbs</b>
 $ <b>ln -s /DBinformix/siasdbs siasdbs</b>
 $ <b>ln -s /DBinformix/sieradbs sieradbs</b>

The file<tt> $INFORMIXDIR/etc/sqlhosts </tt>must have the following syntax:
 &lt;database servername&gt; &lt;protocol&gt; &lt;hostname&gt; &lt;service&gt;

In our example the file<tt> /opt/informix/etc/sqlhosts </tt>has the following entries:
 sisis onipcshm sh-dz sisis_shm
 sisis_tcp onsoctcp sh-dz sqlturbo

The next step is to create the file<tt> $INFORMIXDIR/etc/onconfig.sisis </tt>:
 $ <b>cd /opt/informix/etc</b>
 $ <b>cp onconfig.std onconfig.sisis</b>

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:
 $ <b>cd /home/informix</b>
 $ <b>mkdir sicherung.sisis</b>
 $ <b>chmod 775 sicherung.sisis</b>
 $ <b>cd sicherung.sisis</b>
 $ <b>cat /dev/null > level0</b>
 $ <b>chmod 666 level0</b>
 $ <b>mkdir logfiles</b>
 $ <b>chmod 775 logfiles</b>

Now initialize the server "sisis".
 $ <b>oninit -i</b>
 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)? <b>y</b>
 
Don't get nervous - this may take some minutes!

Note: Check the file<tt> online.log </tt>for the entries:
 'sysmaster' database built successfully.
 'sysutils' database built successfully.

Monitor the operation of the database server, showing the dbspaces and chunks:
 $ <b>onstat -d</b>
 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":
 $ <b>onspaces -c -d sisisdbs -p /home/informix/links/sisisdbs -o 0 -s 2000000</b>

If necessary, also create the following dbspaces:
 $ <b>onspaces -c -d sisisdbs -p /home/informix/links/logdbs -o 0 -s &lt;size in pages&gt;</b>
 $ <b>onspaces -c -d sisisdbs -p /home/informix/links/physdbs -o 0 -s &lt;size in pages&gt;</b>
 $ <b>onspaces -c -d sisisdbs -p /home/informix/links/siasdbs -o 0 -s &lt;size in pages&gt;</b>
 $ <b>onspaces -c -d sisisdbs -p /home/informix/links/sieradbs -o 0 -s &lt;size in pages&gt;</b>
 $ <b>onspaces -c -d sisisdbs -p /home/informix/links/sikisdbs -o 0 -s &lt;size in pages&gt;</b>

Finally create the dbspace "tempdbs" with these options:
 $ <b>onspaces -c -t -d tempdbs -p /home/informix/links/tempdbs -o 0 -s 1000000</b>

After this change the variable<tt> DBSPACETEMP </tt>in the file<tt> $INFORMIXDIR/etc/onconfig.sisis </tt> (this can only be done now!):
 $ <b>vi /opt/informix/etc/onconfig.sisis</b>
 DBSPACETEMP	/home/informix/links/tempdbs     # Default temp dbspaces

At last perform a level0 archive (the archive will be created at<tt> $TAPEDEV/level0</tt> ):
 $ <b>ontape -s -L 0</b>


{{cat|Informix-Online}}
{{cat|Informix Software}}