WordPress 里面 phanx.wordpress.com 不知道为什么是保留站点，不让我注册。
从2009年底起，本人由于工作变动，所从事的领域由原来的网络变成了现在的系统，因此博客中涉及的内容也转变成了系统方面的内容。 还由于wordpress.com这里免费的Blog限制3G大小（虽然不知道我到底能不能写到那么多。。。）和国内访问不便，因此，Blog转向chinaunix.net提供的博客空间 phanx.blog.chinaunix.net 。而我的域名 phanx.com 的指向也修改到那里了。欢迎访问。 www.phanx.com
1.1、准备informix的组和用户
创建informix组和用户并设置密码
groupadd informix
useradd -g informix informix
passwd informix
将JDK拷贝到/usr/local 下并安装
cp jdk-1_5_0_04-linux-i586.bin /usr/local
cd /usr/local
./jdk-1_5_0_04-linux-i586.bin
在/usr/bin下创建java的链接，或者直接设置JAVA_HOME变量
cd /usr/bin
ln –s /usr/local/ jdk1.5.0_04/bin/java java
export JAVA_HOME=/usr/local/jdk1.5.0_04
添加INFORMIXDIR环境变量
export INFORMIXDIR=/home/informix
将安装包解压缩后执行安装程序
tar xvf ./informix-linux.tar –C ./informix
根据提示，按照默认设置安装
cd informix
./ids_install
Initializing InstallShield Wizard……..
Launching InstallShield Wizard……..
1. Release Notes
2. Installation Guide
3. Begin Installation
Please select one of these options [3]
Beginning installation…
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
Welcome to the InstallShield Wizard for IBM Informix Dynamic Server Bundle
The InstallShield Wizard will install IBM Informix Dynamic Server Bundle on
your computer.
To continue, choose Next.
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
Language not supported in console mode, will display in English
Software Licensing Agreement
Press Enter to display the license agreement on your screen. Please
read the agreement carefully before installing the Program. After
reading the agreement, you will be given the opportunity to accept it
or decline it. If you choose to decline the agreement, installation
will not be completed and you will not be able to use the Program.
1
International Program License Agreement
Part 1 – General Terms
BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, OR USING
THE PROGRAM YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU
ARE ACCEPTING THESE TERMS ON BEHALF OF ANOTHER PERSON OR A
COMPANY OR OTHER LEGAL ENTITY, YOU REPRESENT AND WARRANT
THAT YOU HAVE FULL AUTHORITY TO BIND THAT PERSON, COMPANY,
OR LEGAL ENTITY TO THESE TERMS. IF YOU DO NOT AGREE TO
THESE TERMS,
– DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, OR USE THE
PROGRAM; AND
– PROMPTLY RETURN THE PROGRAM AND PROOF OF ENTITLEMENT TO
THE PARTY FROM WHOM YOU ACQUIRED IT TO OBTAIN A REFUND OF
THE AMOUNT YOU PAID. IF YOU DOWNLOADED THE PROGRAM, CONTACT
THE PARTY FROM WHOM YOU ACQUIRED IT.
"IBM" is International Business Machines Corporation or one
of its subsidiaries.
"License Information" ("LI") is a document that provides
information specific to a Program. The Program’s LI is
available at http://www.ibm.com/software/sla/ . The LI may
also be found in a file in the Program’s directory, by the
use of a system command, or as a booklet which accompanies
the Program.
Press Enter to continue viewing the license agreement, or, Enter 1 to
accept the agreement, 2 to decline it or 99 to go back to the previous
screen.
1
按 1 到下一步, 3 取消 或者 4 重新显示 [1]
IBM Informix Dynamic Server Bundle Install Location
Please specify a directory or press Enter to accept the default directory.
Directory Name: [/home/informix]
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
Searching for products available for install: this may take a few minutes.
Select the products you would like to install:
To select/deselect a product or to change its setup type, type its number:
Product Setup Type
———————————————— ————————
1. [ ] IBM Informix IConnect
2. [x] IBM Informix Client-SDK Typical
3. [x] IBM Informix Dynamic Server Typical
4. [x] IBM Informix JDBC Driver
Other options:
0. Continue installing
Enter command [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
Do you want to enable role separation?
[ ] 1 – Yes
[X] 2 – No
To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
Would you like to create an IDS demo instance?
[ ] 1 – Create Demo
[X] 2 – Do Not Create Demo
To select an item enter its number, or 0 when you are finished: [0]
The primary purpose of the demo instance is to ensure that the product is
properly installed and the hardware is configured to work with IDS.
This demo instance can be used as an actual production instance if properly
configured.
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
IBM Informix Dynamic Server Bundle will be installed in the following location:
/home/informix
with the following features:
IBM Informix Client-SDK
IBM Informix Dynamic Server
IBM Informix JDBC Driver
for a total size:
51.6 MB
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
Creating uninstaller…
0 % complete
10 % complete
20 % complete
30 % complete
40 % complete
50 % complete
60 % complete
70 % complete
80 % complete
90 % complete
100 % complete
Installing IBM Informix JDBC Driver. Please wait…
Creating uninstaller…
Installing Message Files by RPM
Installing GLS Files by RPM
Installing IDS Files by RPM
Installing SDK Message Files by RPM
Installing SDK GLS Files by RPM
Installing SDK Files by RPM
Branding Files …
Installing directory .
Installing directory etc
Installing directory bin
Installing directory lib
Installing directory lib/client
Installing directory lib/client/csm
Installing directory lib/esql
Installing directory lib/dmi
Installing directory lib/c++
Installing directory lib/cli
Installing directory release
Installing directory release/en_us
Installing directory release/en_us/0333
Installing directory incl
Installing directory incl/esql
Installing directory incl/dmi
Installing directory incl/c++
Installing directory incl/cli
Installing directory demo
Installing directory demo/esqlc
Installing directory demo/c++
Installing directory demo/cli
Installing directory doc
Installing directory doc/gls_api
Installing directory doc/gls_api/en_us
Installing directory doc/gls_api/en_us/0333
IBM Informix Product: IBM INFORMIX-Client SDK
Installation Directory: /home/informix
Performing root portion of installation of IBM INFORMIX-Client SDK…
Installation of IBM INFORMIX-Client SDK complete.
Installing directory etc
Installing directory gls
Installing directory gls/cm3
Installing directory gls/cv9
Installing directory gls/dll
Installing directory gls/etc
Installing directory gls/lc11
Installing directory gls/lc11/cs_cz
Installing directory gls/lc11/da_dk
Installing directory gls/lc11/de_at
Installing directory gls/lc11/de_ch
Installing directory gls/lc11/de_de
Installing directory gls/lc11/en_au
Installing directory gls/lc11/en_gb
Installing directory gls/lc11/en_us
Installing directory gls/lc11/es_es
Installing directory gls/lc11/fi_fi
Installing directory gls/lc11/fr_be
Installing directory gls/lc11/fr_ca
Installing directory gls/lc11/fr_ch
Installing directory gls/lc11/fr_fr
Installing directory gls/lc11/is_is
Installing directory gls/lc11/it_it
Installing directory gls/lc11/ja_jp
Installing directory gls/lc11/ko_kr
Installing directory gls/lc11/nl_be
Installing directory gls/lc11/nl_nl
Installing directory gls/lc11/no_no
Installing directory gls/lc11/os
Installing directory gls/lc11/pl_pl
Installing directory gls/lc11/pt_br
Installing directory gls/lc11/pt_pt
Installing directory gls/lc11/ru_ru
Installing directory gls/lc11/sk_sk
Installing directory gls/lc11/sv_se
Installing directory gls/lc11/th_th
Installing directory gls/lc11/zh_cn
Installing directory gls/lc11/zh_tw
IBM Informix Product: Gls
Installation Directory: /home/informix
Performing root portion of installation of Gls…
Installation of Gls complete.
Installing directory etc
Installing directory msg
Installing directory msg/en_us
Installing directory msg/en_us/0333
IBM Informix Product: messages
Installation Directory: /home/informix
Performing root portion of installation of messages…
Installation of messages complete.
Branding Installed Files …
Please read the information below.
Set required environment variables
Set $INFORMIXDIR to the directory where the IDS server is installed.
Set $PATH to include $INFORMIXDIR/bin
Set $INFORMIXSERVER to the name of the database server
Set $ONCONFIG to the name of the active onconfig configuration file.
If using a sqlhosts file other than $INFORMIXDIR/etc/sqlhosts
Set $INFORMIXSQLHOSTS
If using a locale/language other than the default
Set $CLIENT_LOCALE
Set $DB_LOCALE
Set $SERVER_LOCALE
Set $DBLANG
Prepare connectivity files
sqlhosts
/etc/hosts
/etc/services
Prepare configuration file
Set DBSERVERNAME
Set SERVERNUM
Set ROOTNAME
Press ENTER to read the text [Type q to quit]
Set ROOTPATH
Set ROOTSIZE
Initialize database server
As informix or root, run oninit
If initializing a new server for the FIRST time, run oninit -i
This will overwrite any existing data, so use caution on an exis
ting setup
For more information please refer to the IBM Informix Dynamic Server Getting
Started Guide
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
The InstallShield Wizard has successfully installed IBM Informix Dynamic Server
Bundle. Choose Next to continue the wizard.
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
1. Release Notes
2. Quick Beginnings Guide
3. Finish Installation
Please select one of these options [3]
Finishing Installation…
Press 3 to Finish or 4 to Redisplay [3]
1.1、修改informix运行时的环境变量
修改informix用户的环境变量
vi /home/informix/.bash_profile
PATH=$PATH:$HOME/bin
INFORMIXDIR=/home/informix
INFORMIXTMP=/home/informix/tmp
INFORMIXSERVER=testsvr
ONCONFIG=onconfig
TERMCAP=$HOME/etc/termcap
export PATH INFORMIXDIR INFORMIXTMP INFORMIXSERVER ONCONFIG TERMCAP
拷贝etc下的onconfig.std和sqlhosts.std为环境变量中所设置的名称
cd /home/informix/etc
cp onconfig.std onconfig
cp sqlhosts.std sqlhosts
使用root用户修改/etc/services文件，增加informix服务
# Local services
informix 60000/tcp # Informix Server
1.4、修改informix配置文件
使用informix用户修改sqlhost和onconfig文件
vi /home/informix/etc/sqlhosts
#ServerName Connect Hostname ServicesName(对应/etc/services中)
testsvr onsoctcp localhost informix
vi /home/informix/etc/onconfig
DBSERVERNAME testsvr
TAPEDEV /dev/null # Tape device path
LTAPEDEV /dev/null # Log tape device path
将默认/usr/informix/ 替换为 /home/informix/
vi命令 1,$ s/\/usr\/informix\//\/home\/informix\//g
1.5、修改informix的tmp目录属性
修改/home/informix/tmp的属性
chmod o-r /home/informix/tmp
chmod o-x /home/informix/tmp
1.1、采用RAW设备方式存储数据
增加LV，rootdbs大小对应config文件中的大小
lvcreate –size 1G –name nwrootdbs datavg
lvcreate –size 512M –name nwphydbs datavg
lvcreate –size 512M –name nwlogdbs datavg
lvcreate –size 512M –name nwtmpdbs datavg
lvcreate –size 512M –name nwidxdbs datavg
lvcreate –size 1G –name nwdatadbs datavg
1.1.2、创建LV对应的RAW设备
创建RAW设备
raw /dev/raw/raw1 /dev/datavg/nwrootdbs
raw /dev/raw/raw2 /dev/datavg/nwphydbs
raw /dev/raw/raw3 /dev/datavg/nwlogdbs
raw /dev/raw/raw4 /dev/datavg/nwtmpdbs
raw /dev/raw/raw5 /dev/datavg/nwidxdbs
raw /dev/raw/raw6 /dev/datavg/nwdatadbs
1.1.3、配置启动时候自动创建LV对应的RAW设备
由于Linux不会自动创建LV对应的RAW设备，所以建议将raw设备设定为启动时候自动添加。
1.1.3.1、RHEL 5以后版本
可以通过修改 /etc/rc.local ，加入以上创建RAW设备的命令。
或者在/etc/udev/rules.d/60-raw.rules中配置
ACTION=="add", ENV{MAJOR}=="253", ENV{MINOR}=="2", RUN+="/bin/raw /dev/raw/raw1 %M %m"
ACTION=="add", ENV{MAJOR}=="253", ENV{MINOR}=="3", RUN+="/bin/raw /dev/raw/raw2 %M %m
ACTION=="add", ENV{MAJOR}=="253", ENV{MINOR}=="4", RUN+="/bin/raw /dev/raw/raw3 %M %m"
ACTION=="add", ENV{MAJOR}=="253", ENV{MINOR}=="5", RUN+="/bin/raw /dev/raw/raw4 %M %m"
ACTION=="add", ENV{MAJOR}=="253", ENV{MINOR}=="6", RUN+="/bin/raw /dev/raw/raw5 %M %m"
ACTION=="add", ENV{MAJOR}=="253", ENV{MINOR}=="7", RUN+="/bin/raw /dev/raw/raw6 %M %m"
注：其中ENV的MAJOR和MINOR值，可以从手工创建RAW设备时候得到。
[root@localhost ~]# raw /dev/raw/raw1 /dev/datavg/nwrootdbs
/dev/raw/raw1: bound to major 253, minor 2
1.1.3.2、RHEL 5以前版本
在以前的RedHat Enterprise Linux Server 5版本以前，系统是通过/etc/sysconfig/rawdevices配置raw的控制文件，通过/etc/init.d/rawdevices来管理raw设备的启动和关闭。所以，如果对应系统为RHEL5以前的版本，那么在/etc/sysconfig/rawdevices中添加一下配置
/dev/raw/raw1 /dev/datavg/nwrootdbs
/dev/raw/raw2 /dev/datavg/nwphydbs
/dev/raw/raw3 /dev/datavg/nwlogdbs
/dev/raw/raw4 /dev/datavg/nwtmpdbs
/dev/raw/raw5 /dev/datavg/nwidxdbs
/dev/raw/raw6 /dev/datavg/nwdatadbs
1.1.4、修改LV设备文件和RAW设备文件权限
修改LV和RAW设备所属和权限
chown informix:informix /dev/mapper/datavg-nw*
chmod 660 /dev/mapper/datavg-*nw
chown informix:informix /dev/raw/raw1
chown informix:informix /dev/raw/raw2
chown informix:informix /dev/raw/raw3
chown informix:informix /dev/raw/raw4
chown informix:informix /dev/raw/raw5
chown informix:informix /dev/raw/raw6
chmod 660 /dev/raw/raw1
chmod 660 /dev/raw/raw2
chmod 660 /dev/raw/raw3
chmod 660 /dev/raw/raw4
chmod 660 /dev/raw/raw5
chmod 660 /dev/raw/raw6
同样的，如果设定了启动时候自动添加raw设备定，那么也需要在/etc/rc.local中添加修改RAW设备所属和权限的命令
chown informix:informix /dev/raw/raw1
chown informix:informix /dev/raw/raw2
chown informix:informix /dev/raw/raw3
chown informix:informix /dev/raw/raw4
chown informix:informix /dev/raw/raw5
chown informix:informix /dev/raw/raw6
chmod 660 /dev/raw/raw1
chmod 660 /dev/raw/raw2
chmod 660 /dev/raw/raw3
chmod 660 /dev/raw/raw4
chmod 660 /dev/raw/raw5
chmod 660 /dev/raw/raw6
1.1.5、为RAW设备创建链接
在/dev/datavg下创建链接（可选）
ln -s /dev/raw/raw1 /dev/datavg/rnwrootdbs
ln -s /dev/raw/raw2 /dev/datavg/rnwphydbs
ln -s /dev/raw/raw3 /dev/datavg/rnwlogdbs
ln -s /dev/raw/raw4 /dev/datavg/rnwtmpdbs
ln -s /dev/raw/raw5 /dev/datavg/rnwidxdbs
ln -s /dev/raw/raw6 /dev/datavg/rnwdatadbs
在/home/informix/下创建chunk的目录和链接
mkdir /home/informix/dbspaces
ln -s /dev/raw/raw1 rootdbschunks
ln -s /dev/raw/raw2 phydbschunks
ln -s /dev/raw/raw3 logdbschunks
ln -s /dev/raw/raw4 tmpdbschunks
ln -s /dev/raw/raw5 idxdbschunks
ln -s /dev/raw/raw6 datadbschunks
1.1.6、修改onconfig文件
修改onconfig文件中的rootdbs位置和大小
vi /home/informix/etc/onconfig
ROOTPATH /home/informix/dbspaces/rootdbschunks
ROOTOFFSET 100
ROOTSIZE 1048476 #512M 1024*1024-OFFSET= 1048576
[K1]在RHEL 5.3上测试没有成功，建议还是采用在/etc/rc.local下配置raw命令来创建RAW设备。
1.1、采用文件系统方式存储数据
1.1.1、创建存储文件
创建一个存放数据库文件的目录 /home/informix/dbspaces
mkdir /home/informix/dbspaces
建立rootdbs的存储文件/home/informix/dbspaces/rootdbs (空文件)
cat /dev/null > /home/informix/dbspaces/rootdbs
修改所属和权限
chown informix:informix /home/informix/dbspaces/rootdbs
chmod 660 /home/informix/dbspaces/rootdbs
1.1.2、修改onconfig文件
修改onconfig文件中的rootdbs位置和大小
vi /home/informix/etc/onconfig
ROOTPATH /home/informix/dbspaces/rootdbs
ROOTOFFSET 0
ROOTSIZE 1048576 #1G 1024*1024-OFFSET= 1048576
启动并初始化Informix Server
alias oninitfirst=”oninit -iv”
oninitfirst
This action will initialize IBM Informix Dynamic Server;
any existing IBM Informix Dynamic Server databases will NOT be accessible –
Do you wish to continue (y/n)? y
Checking group membership to determine server run mode…succeeded
Reading configuration file ‘/home/informix/etc/onconfig’…succeeded
Creating /INFORMIXTMP/.infxdirs…succeeded
Creating infos file "/home/informix/etc/.infos.testsvr"…succeeded
Linking conf file "/home/informix/etc/.conf.testsvr"…succeeded
Writing to infos file…succeeded
Checking config parameters…Invalid value of DUMPDIR ‘/usr/informix/tmp’ in onconfig file. Setting it to default value
‘/home/informix/tmp’…succeeded
13:50:32 IBM Informix Dynamic Server Started.
Allocating and attaching to shared memory…succeeded
Creating resident pool 866 kbytes…succeeded
Allocating 18384 kbytes for buffer pool of 2K page size…succeeded
Initializing rhead structure…succeeded
Thu Dec 10 13:50:32 2009
13:50:32 Event alarms enabled. ALARMPROG = ‘/usr/informix/etc/alarmprogram.sh’
Initializing ASF…succeeded
Initializing Dictionary Cache and SPL Routine Cache…13:50:32 Booting Language <c> from module <>
13:50:32 Loading Module <CNULL>
13:50:32 Booting Language <builtin> from module <>
13:50:32 Loading Module <BUILTINNULL>
succeeded
Bringing up ADM VP…succeeded
Creating VP classes…succeeded
Onlining 0 additional cpu vps…succeeded
Onlining 2 IO vps…succeeded
Initialization of Encryption…succeeded
Forking main_loop thread…succeeded
Initializing DR structures…13:50:37 DR: DRAUTO is 0 (Off)
succeeded
Forking 1 ‘soctcp’ listener threads…13:50:37 Dynamically allocated new virtual shared memory segment (size 8192KB)
succeeded
13:50:37 IBM Informix Dynamic Server Version 10.00.UC3R1 Software Serial Number AAA#B000000
Starting tracing…succeeded
Initializing 1 flushers…succeeded
Initializing log/checkpoint information…succeeded
Opening primary chunks…succeeded
Opening mirror chunks…succeeded
Initializing dbspaces…succeeded
Validating chunks…succeeded
Creating database partition…succeeded
Initialize Async Log Flusher…succeeded
13:50:39 IBM Informix Dynamic Server Initialized — Complete Disk Initialized.
Forking btree cleaner…succeeded
Initializing DBSPACETEMP list…succeeded
Checking database partition index…succeeded
13:50:39 Checkpoint Completed: duration was 0 seconds.
13:50:39 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x4f
13:50:39 Maximum server connections 0
Checking location of physical log…succeeded
Initializing dataskip structure…13:50:39 Dataskip is now OFF for all dbspaces
succeeded
Checking for temporary tables to drop…succeeded
Forking onmode_mon thread…succeeded
Verbose output complete: mode = 5
13:50:39 On-Line Mode
13:50:39 Building ‘sysmaster’ database …
[informix@localhost ~]$ 13:50:40 Booting Language <spl> from module <>
13:50:40 Loading Module <SPLNULL>
13:50:40 Unloading Module <SPLNULL>
13:50:40 Logical Log 2 Complete, timestamp: 0x93ba.
13:50:40 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 2 Complete, timestamp: 0x93ba." "Logical Log 2 Com
13:50:41 Loading Module <SPLNULL>
13:50:42 ‘sysmaster’ database built successfully.
13:50:42 ‘sysutils’ database built successfully.
13:50:42 ‘sysuser’ database built successfully.
13:50:42 Logical Log 3 Complete, timestamp: 0xe915.
13:50:42 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/etc/alarmprogram.sh 2 23 "Logical Log 3 Complete, timestamp: 0xe915." "Logical Log 3 Com
1.1、调整默认的DBSpaces到独立的RAW设备
建立其余DBSpace的chunk
-s size 的数值计算方法： dbs所在的raw设备LV的大小（KB）减去-o offset的值
onspaces -c -d phydbs -p /home/informix/dbspaces/phydbschunks -o 100 -s 1048476
onspaces -c -d logdbs -p /home/informix/dbspaces/logdbschunks -o 100 -s 524188
onspaces -c -t -d tmpdbs -p /home/informix/dbspaces/tmpdbschunks -o 100 -s 524188
onspaces -c -d idxdbs -p /home/informix/dbspaces/idxdbschunks -o 100 -s 524188
onspaces -c -d datadbs -p /home/informix/dbspaces/datadbschunks -o 100 -s 1048476
至少创建三个逻辑日志文件
调整informix使用的LOG文件到新加入的逻辑日志文件上，再将检查点记录同步到逻辑日志文件
onmode -l
onmode -l
onmode -l
onmode -c
用循环添加Log到logdbschunk全部占用满。
while true; do onparams -a -d logdbs -s 15000; done;
在提示DBSpace is full.的时候，用Ctrl-C中断循环。
删除原rootdbs上的逻辑日志文件
onparams -d -l 1
onparams -d -l 2
onparams -d -l 3
注：
如果采用的是文件系统方式存储，那么在初始化informix数据库之前，可以通过修改onconfig文件中的逻辑日志相关配置来指定逻辑日志文件的大小和数量。
onconfig中的
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 200000 # Physical log file size (Kbytes)
不能直接修改，需要在quiescent模式下使用 onparams -p -s pagesize -d dbspace 命令来调整。
pagesize大小为LV大小（KB）减去offset值，即采用onspaces创建的phydbs的大小。
onmode -sy
onparams -p -s 1048476 -d phydbs
informix的 oninit 必须是 root:informix 权限为 6754 ，否则oninit无法启动或者启动后用dbaccess连接测试会报告informix用户密码错误。
phanx.com 