Full introduction to informixforlinux Installation

Full introduction to informixforlinux installation-Linux Enterprise Application-Linux server application information. The following is a detailed description. Step 1: Download
Ids 9.4 for linux:
Ftp://ftp.youngcow.net/Special/D... G-IDS-9.4-linux.zip
This thread has restrictions
Http: // 202.96.110.20./ informix/ids9.4/IIUG-IDS-9.4-linux.zip
This is faster, depending on the network;

Csdk for linux:
Ftp://ftp.software.ibm.com/softw... 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
I don't need to explain this;

Step 3: Prepare the Installation File
I don't need to mention it when extracting the zip file.

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 You can see the generated file;

Open clientsdk.2.81.UC2.LINUX.tar: tar xvf clientsdk.2.81.UC2.LINUX.tar;
Generate csdk. cpi;

Unlock csdk. cpi cpio-idmv You can see the generated file;

Step 4: Start Installation
First, use informix User Login

Install ids: Run./installserver In the informix directory

Press enter when prompted;

Run RUN_AS_ROOT.server as the root user;

In this way, your ids has been installed;

Install csdk: Run./installclientsdk in the inforomix directory;

Press yes when prompted, and press Enter;

Then, su runs RUN_AS_ROOT.clientsdk to the root user;

In this way, 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 indicates the host name, And sqlexe/sqlexec indicates the services configured in the services file;
-- Note that the release in informix for linux 9.4 does not support the tlitcp method, so the onsoctcp method is used here;
-- If the tlitcp mode is configured in the sqlhosts file or the configuration in the sqlhosts file is different from that in the onconfig. cs file, a 25507 error is frequently encountered by many people;

4. Create a space
Operate with informix users
Create a dbs directory in INFORMIXDIR (easy to differentiate and pull)
First touch rootdbs logdbs phydbs blobdbs tmpdbs datadbs
Then chmod 660 *
Make sure that all dbs 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)

-- Use the default logical log
# 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/

6. Database Initialization
Oninit-ivy
You can use onstat-I to view the result.
Informix Dynamic Server Version 9.40.UC1E1 -- On-Line -- Up 00:31:47 -- 18872
Kbytes
Onstat>

7. Improve database space

The following provides a frequently used shell

Echo "Add blobdbs, tmpdbs0, phydbs, logdbs ..."
Echo "============================================== ===================="

Onspaces-c-B blobdbs-g 32-p/home/informix/dbs/blobdbs-o 0-s 48000
Onspaces-c-d tmpdbs-t-p/home/informix/dbs/tmpdbs-o 0-s 100000

Onspaces-c-d phydbs-p/home/informix/dbs/phydbs-o 0-s 50200
Onspaces-c-d logdbs-p/home/informix/dbs/logdbs-o 0-s 200000

Echo "\ nShut Down Server to Quiescent Mode ..."
Echo "============================================== ===================="
Onmode-s-y
Sleep 5

Echo "Adding Logical Log \ n"
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 20000
Onparams-a-d logdbs-s 10000

Echo "\ nArchiving Database Server Please Wait 20 seconds. \ n"
Echo "============================================== ===================="
Ontape-s
Sleep 5

Onmode-l
Onmode-l
Onmode-l
Onmode-l
Onmode-l
Onmode-l
Onmode-c
Sleep 10

Echo "\ nDrop the old Logical Log Files... \ n"
Echo "============================================== ===================="
Onparams-d-l 1-y
Onparams-d-l 2-y
Onparams-d-l 3-y
Onparams-d-l 4-y
Onparams-d-l 5-y
Onparams-d-l 6-y

Echo "\ nChange Physical Log Files, please wait about 1 minutes... \ n"
Echo "============================================== ===================="
Onparams-p-s 50000-d phydbs-y
Sleep 100

Echo "\ nNow add more dbspaces/chunks... \ n"
Echo "============================================== ===================="

Onspaces-c-d datadbs-p/home/informix/dbs/datadbs-o 0-s 500000

Echo "\ nTake a level 0 archive. \ n"
Echo "============================================== ===================="

Ontape-s-L 0

Echo "\ nReboot IDS... \ n"
Echo "============================================== ===================="

Onmode-ky
Oninit

Sleep 10

Echo "\ n ========================================== ========================"
Echo "Well done! \ N"
Echo "============================================== ===================="

Finally, modify the onconfig. cs file.
DBSPACETEMP tmpdbs # Default temp dbspaces
Onmode-ky
Oninit