分类: DB2/Informix
2008-08-01 10:14:30
九、配置informix
1,初始化配置
准备数据库server用onconfig文件和修改sqlhosts
n 以informix用户注册,进入$INFORMIXDIR/etc目录,执行cp onconfig.std onconfig.数据库server名,其中onconfig文件名和informix的.profile中的设置对应。
在此处执行命令:# cd /home/db/informix/etc
# cp onconfig.std onconfig.front
n 调整informix数据库配置参数
编辑onconfig.front,修改以下参数
ROOTSIZE rootdbs大小 500000
ROOTPATH /home/db/Informix/dbs/rootchunk0
PHYSFILE 100 MB
LOGFILES 3 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
SERVERNUM 0
NETTYPE soctcp,3,200,NET
MULTIPROCESSOR 1
NUMCPUVPS 3
LOCKS 3000000
BUFFERS 800000
NUMAIOVPS 8
PHYSBUFF 256
LOGBUFF 256
CLEANERS 16
SHMVIRTSIZE 384000
SHMADD 128000
TAPEDEV /dev/null
LTAPEDEV /dev/null
DBSERVERNAME front
MSGPATH /home/db/informix
CONSOLE INFORMIXDIR/log/console.log
ALARMPROGRAM INFORMIXDIR/etc/log_full.sh
DBSPACETEMP
其它参数暂时默认即可。
NOTE:第一次修改onconfig.front文件的时候,务必在PHYDBS参数后写上rootdbs,而不要写phydbs01,否则初始化失败。
n 设置INFORMIXDIR/etc/sqlhosts文件
编辑sqlhosts文件,加入配置的informix的信息,其中severname、portname 分别与informix的.profile中的INFORMIXSERVER及/etc/services下的端口号对应。
servername ontlitcp your_host_name portname
front onscotcp 192.168.1.10 informixport(20000)
n 编辑/etc/services文件,添加以下内容:
informixport 20000/tcp #Informix port
2,创建符号链接
# su - informix
rx8640-2:/home/db/informix/dbs> mkdir dbs
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013000 rootchunk0
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013001 phychunk0
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013002 tmpchunk0
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013003 tmpchunk1
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013004 tmpchunk2
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013005 logchunk0
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013006 workchunk0
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013007 workchunk1
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013008 workchunk2
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013009 workchunk3
rx8640-2:/home/db/informix/dbs> ln -s /dev/vg00/rlgntv0013010 workchunk4
rx8640-2:/home/db/informix/dbs> ll
total 0
lrwxrwxrwx 1 informix informix 23 Jul 29 12:40 logchunk0 -> /dev/vg00/rlgntv0013005
lrwxrwxrwx 1 informix informix 23 Jul 29 12:40 phychunk0 -> /dev/vg00/rlgntv0013001
lrwxrwxrwx 1 informix informix 23 Jul 29 12:39 rootchunk0 -> /dev/vg00/rlgntv0013000
lrwxrwxrwx 1 informix informix 23 Jul 29 12:40 tmpchunk0 -> /dev/vg00/rlgntv0013002
lrwxrwxrwx 1 informix informix 23 Jul 29 12:40 tmpchunk1 -> /dev/vg00/rlgntv0013003
lrwxrwxrwx 1 informix informix 23 Jul 29 12:40 tmpchunk2 -> /dev/vg00/rlgntv0013004
lrwxrwxrwx 1 informix informix 23 Jul 29 12:41 workchunk0 -> /dev/vg00/rlgntv0013006
lrwxrwxrwx 1 informix informix 23 Jul 29 12:41 workchunk1 -> /dev/vg00/rlgntv0013007
lrwxrwxrwx 1 informix informix 23 Jul 29 12:41 workchunk2 -> /dev/vg00/rlgntv0013008
lrwxrwxrwx 1 informix informix 23 Jul 29 12:41 workchunk3 -> /dev/vg00/rlgntv0013009
lrwxrwxrwx 1 informix informix 23 Jul 29 12:42 workchunk4 -> /dev/vg00/rlgntv0013010