Install Informix for linux (1)

Step 1: Download ids 9.4 for linux

Ftp://ftp.youngcow.net/Special/Database/DatabaseServer/Informix/InformixDynamicServerVersion9.4/IIUG-IDS-9.4-linux.zip

This thread has limits on http: // 202.96.110.20./ informix/ids9.4/IIUG-IDS-9.4-linux.zip
Csdk for linux:
Ftp://ftp.software.ibm.com/software/data/informix/downloads/clientsdk.2.81.UC2.LINUX.tar
Step 2: Build an informix installation environment in linux
Create an informix group: groupadd-g 20000 informix
Create informix User: useradd-u 20000-g 20000-d/home/informix-m informix
Modify informix user environment variables:
Add the following environment variables to the. bash_profile file:
INFORMIXDIR =/home/informix
INFORMIXSERVER = cs_dbs
ONCONFIG = onconfig. cs
DBDATE = MDY4 *
LD_LIBRARY_PATH = $ INFORMIXDIR/lib: $ INFORMIXDIR/lib/esql: $ LD_LIBRARY_PATH
Export informixdir informixserver onconfig LD_LIBRARY_PATH
PATH = $ PATH: $ INFORMIXDIR/bin
Export PATH
Step 3: Prepare the Installation File
Decompress the ZIP file to transfer the extracted linux-ids.9.40.tc1e1.cpioand clientsdk.2.81.uc2.linux.tar files to the environment;
Unzipping Linux-IDS.9.40.tc1e1.cpio: cpio-idmv Open clientsdk.2.81.UC2.LINUX.tar: tar xvf clientsdk.2.81.UC2.LINUX.tar; generate csdk. cpi;
Unlock csdk. cpi cpio-idmv Step 4: Start Installation

First, use the informix user to log on and install ids: Run./installserver In the informix directory. Run the prompt and press Enter. After the operation is complete, run RUN_AS_ROOT.server to the root user. Then, your ids will be installed.
Install csdk: Run./installclientsdk in the inforomix directory. When you encounter a prompt, press "yes" and press Enter. After that, run RUN_AS_ROOT.clientsdk to the root user. Then, your clientsdk is installed.

Step 5: Start Configuration
1. Configure the/etc/services file
Sqlexe 1526/tcp
Sqlexec 1528/tcp
-- Sqlexe and sqlexec are service names, and 1526 and 1528 are port numbers;
-- TCP/IP indicates the TCP/IP protocol
2. Configure the/etc/hosts file
192.168.28.1 linux (host name)
3. Configure the $ INFORMIXDIR/etc/sqlhosts File
Cs_dbs onipcshm linux sqlexe
Cs_dbs_tcp onsoctcp linux sqlexec
The shared memory mode and soctcp mode are configured to connect to the database. linux represents the host name, And sqlexe/sqlexec represents the services configured in the services file, respectively, in informix for linux 9.4, release mentioned that the tlitcp method is not supported. Therefore, the onsoctcp method is used here. If the sqlhosts file is configured with the tlitcp method or the configuration in the sqlhosts file and onconfig. different cs file configurations may lead to 25507 errors that many people often encounter;
4. Create a space
Create a dbs directory in INFORMIXDIR using informix user operations (easy to differentiate)
First touch rootdbs logdbs phydbs blobdbs tmpdbs datadbs; then chmod 660 * ensures that all dbs files are in the informix user informix group; the permissions are 660;
5. Configure the $ INFORMIXDIR/etc/onconfig. cs file.

The following are some notes:
Rootdbs path and Space
ROOTNAME rootdbs # Root dbspace name
ROOTPATH/home/informix/dbs/rootdbs # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 100000 # Size of root dbspace (Kbytes)
The dbs space of physical logs should be 20 mb of rootdbs first;
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 20000 # Physical log file size (Kbytes)
Logical logs use the default
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
Change everything on the tape to/dev/null.
TAPEDEV/dev/null # Tape device path
TAPEBLK 32 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV/dev/null # Log tape device path
LTAPEBLK 32 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
Configure Database Server parameters and allocate locks and buffers based on the actual configuration of your machine;
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME cs_dbs # Name of default database server
DBSERVERALIASES cs_dbs_tcp # List of alternate dbservernames
NETTYPE ipcshm, 1, 8, CPU # Configure poll thread (s) for nettype
NETTYPE soctcp, 1, 8, NET # Configure poll thread (s) for nettype
Lock S 5000 # Maximum number of LOCKS
BUFFERS 500 # Maximum number of shared buffers
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x10000000 # Shared memory base address
Shm1_size 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
In addition, replace all/usr/informix in the onconfig. cs file with/home/informix/