Linux 安装 informix

Informix是IBM公司出品的关系数据库管理系统（RDBMS）家族。作为一个集成解决方案，它被定位为作为IBM在线事务处理（OLTP）旗舰级数据服务系统。 IBM对Informix和DB2都有长远的规划，两个数据库产品互相吸取对方的技术优势。在2005年早些时候，IBM推出了Informix Dynamic Server（IDS）第10版。目前最新版本的是IDS11（v11.50，代码名为“Cheetah 2”），，在2008年5月6日全球同步上市，

1、#groupadd informix

#useradd -g informix informix

#passwd informix

# informix

2、vi /home/informix/.bash_profile

INFORMIXDIR=/var/informix

PATH=$INFORMIXDIR/bin:$PATH

LD_LIBRARY_PATH=$INFORMIXDIR/lib:$LD_LIBRARY_PATH

export INFORMIXDIR PATH LD_LIBRARY_PATH

3、#mkdir /usr/java

#cd /usr/java

#/home/informix/Informix_Dynamic_Server_V11.50.UC7_Linux_x86_English/.jvm.bin

4、#cd /home/informix/Informix_Dynamic_Server_V11.50.UC7_Linux_x86_English/

#./ids_install -javahome /usr/java

按照提示，一步一步安装（不创建demo)

5、vi /home/informix/.bash_profile

ONCONFIG=onconfig.infm

SQLHOSTS=sqlhosts

DBSERVERNAME=infm

SERVERNUM=0

INFORMIXSERVER=infm

export ONCONFIG SQLHOSTS DBSERVERNAME SERVERNUM INFORMIXSERVER

#. .bash_profile

6、cd $INFORMIX/etc

cp onconfig.std onconfig.infm

vi onconfig.infm

ROOTPATH=$INFORMIXDIR/chunks/infm.rootdbs

DBSERVERNAME=infm

7、#chown -R informix:informix /var/informix

#cd $INFORMIXDIR

#mkdir chunks

cd chunks

touch infm.rootdbs

chmod 660 infm.rootdbs

onspaces -c -d rootdbs -p /var/informix/chunks/infm.rootdbs -o 0 -s 200000

8、#hostname infm

vi $INFORMIXDIR/etc/sqlhosts

infm onsoctcp infm sqlexecinfm onsoctcp infm sqlexec-ss1

9、vi /etc/hosts

127.0.0.1 infm

10、oninit -ivy

安装过程中出现的问题：

1、$oninit -ivyChecking group membership to determine server run mode…succeededReading configuration file ‘/var/informix/etc/onconfig.infm’…succeededCreating /INFORMIXTMP/.infxdirs…succeededChecking config parameters…succeededAllocating and attaching to shared memory…succeededCreating resident pool 10574 kbytes…succeededAllocating 100016 kbytes for buffer pool of 2K page size…succeededCreating infos file “/var/informix/etc/.infos.infm”…succeededLinking conf file “/var/informix/etc/.conf.infm”…succeededoninit: DBSERVERNAME ‘infm’ not in sqlhosts file or sqlhosts file contents are damaged.

刚开始我用的文件不是sqlhosts,而是sqlhosts.infm，这样不行！

2、

Starting tracing…succeededInitializing 8 flushers…succeededFAILED

WARNING: server initialization failed, or possibly timed out (if -w was used).Check the message log, online.log, for errors.

在online.log中发现：

The chunk ‘/var/informix/chunks/infm.rootdbs’ must have READ/WRITE permissions for owner and group (660).

cd $INFORMIXDIR/chunks

$ll

-rw-rw-r– 1 informix informix 0 12-09 22:44 infm.rootdbs

必须是660

chmod 660 infm.rootdbs

人生不如意十之八-九，与其诅咒黑暗，倒不如在生命中点燃一盏灯