【IT168 服务器学院】 一、设置Informix用户环境参数
修改informix用户的.profile,添加如下环境变量:
INFORMIXDIR=$HOME
PATH=$INFORMIXDIR/bin:$PATH
INFORMIXSERVER=主机名_tcp
ONCONFIG=onconfig.life
DBDATE=Y4MD
CLIENT_LOCALE=zh_cn.gb
DB_LOCALE=zh_cn.gb
二、设置主机名及服务端口号
修改/etc/hosts文件,加入下列条目:
主机IP地址 主机名
修改/etc/services文件,加入下列条目:
hb主机名_tcp 8888/tcp
hb主机名_shm 8889/tcp
注意,在services文件的最后一行为空行
三、安装informix数据库软件及工具
1、 准备安装介质
Informix数据库软件的版本全省统一如下:
Online 7.31
Esql 7.23
4gl 7.20
Isql 7.20
2、 安装informix数据库系统
使用root用户使用tar或者cpio命令解压软件包,并执行installsql,installesql,install4gl,installids等命令进行安装。注意在安装过程中遵循先安装低版本,后安装高版本,先安装工具后安装系统的原则,而且要解压一个安装一个,不能解压所有安装包之后一起安装。
3、 配置sqlhosts文件
拷贝/u/informix/etc/sqlhosts.demo文件并命名为sqlhosts,然后用vi修改成如下格式:
Informixserver ontlitcp Hostname ServicesName
4、 配置oncofnig文件
将/u/Informix/etc/onconfig.std拷贝一份命名为onconfig.$INFORMIXSERVER,修改如下参数:
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /u/informix/dbs/rootdbs
# Path for device containing root dbspace
ROOTOFFSET 100 # Offset of root dbspace into device (Kbytes)
ROOTSIZE
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 250000 # Physical log file size (Kbytes)
# Diagnostics
MSGPATH /u/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /u/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /u/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS 1
# System Configuration
SERVERNUM 1 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME $INFORMIXSERVER # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE ipcshm,1,128,CPU # Override sqlhosts nettype parameters
NETTYPE tlitcp,1,128,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 800000 # Maximum number of locks
BUFFERS 400000 # Maximum number of shared buffers
NUMAIOVPS 4 # Number of IO vps
PHYSBUFF 256 # Physical log buffer size (Kbytes)
LOGBUFF 256 # Logical log buffer size (Kbytes)
LOGSMAX 8 # Maximum number of logical log files
CLEANERS 8 # Number of buffer cleaner processes
SHMBASE 0x10000000 # Shared memory base address
SHMVIRTSIZE 8192 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 30 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark
5、 初始化informix
因为已经事先设置好了所有参数,所以,直接用oninit –iy初始化Informix就可以了。
四、添加rootdbs的chunk,迁移logdbs
1、将rootchk02添加到rootdbs中。
2、建立logdbs,迁移逻辑日志
使用onmonitor建立log日志,添加10个逻辑日志到logdbs,并把原来的逻辑日志删除。
重复执行15次如下命令:
onparams -a -d logdbs -s 100000
然后用ontape –s –l 0备份使逻辑日志生效。
删除在rootdbs上的逻辑日志:
onparams -d -l X -y
五、创建workdbs,并添加chunk
创建workdbs,其主chunk为data02,并将其它共20个chunk添加到workdbs中。