IDS.9.40 for linux
1.搭建环境
Groupadd informix
Useradd –g informix –d /home/informix informix
修改informix用户的环境变量
vi .bash_profile
DBPATH=/home/call/forms
INFORMIXDIR=/home/informix
INFORMIXSERVER=informix_ids
ONCONFIG=onconfig_ids
DBDATE=MDY4*
LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH
PATH=$INFORMIXDIR/bin:$PATH
Export INFORMIXSERVER ONCONFIG INFORMIXDIR LD_LIBRARY_PATH PATH DBPATH
2准备安装
解开Linux-IDS.9.40.tc1e1.cpio：cpio -idmv <Linux-IDS.9.40.tc1e1.cpio； 生成的文件； 解开clientsdk.2.81.UC2.LINUX.tar：tar xvf clientsdk.2.81.UC2.LINUX.tar; 生成csdk.cpi;
解开csdk.cpi cpio -idmv <csdk.cpi; 生成的文件；
3 开始安装
首先用informix用户登陆，安装ids：在informix目录下运行./installserver 。碰到提示，直接回车；完成后su到root运行RUN_AS_ROOT.server；这样你的ids就安装好了。
安装csdk：在inforomix目录下运行./installclientsdk; 碰到提示敲yes，回车；完成后su到root运行RUN_AS_ROOT.clientsdk；这样你的clientsdk就装好了
4 开始配置
1配置/etc/services文件
sqlexe 1526/tcp
sqlexec 1528/tcp
--sqlexe和sqlexec是services 名字，1526、1528是端口号；
--TCP/IP表示TCP/IP协议
2配置/etc/hosts文件
218.5.79.91 linux(本主机名称)
3、配置$INFORMIXDIR/etc/sqlhosts文件
informix_ids onipcshm linux sqlexe
informix_ids_tcp onsoctcp linux sqlexec
这里配置了共享内存方式和soctcp方式连接数据库的两种方式；linux代表主机名;sqlexe/sqlexec分别代表在services文件中配的服务； 另外需要注意的是，informix for linux 9.4版中release提到不支持tlitcp方式；所以这里采用的onsoctcp方式；sqlhosts文件配置了tlitcp方式或者说sqlhosts文件中的配置和onconfig.cs文件配置不一样，会出现很多人都经常碰到的25507错误；
4 建立空间
以informix用户操作，在INFORMIXDIR中建立dbs目录；(便于区分)
首先touch rootdbs logdbs phydbs blobdbs tmpdbs datadbs ；然后chmod 660 * 保证所有的dbs文件都是informix用户informix组；权限都是660；
5 配置/home/informix/etc/onconfig_ids
以下列出需要注意的几点内容：
rootdbs路径、空间
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)
物理日志的dbs空间，先用rootdbs的20M；
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 20000 # Physical log file size (Kbytes)
逻辑日志用默认的
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
把磁带的东西都改成/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)
配置数据库服务器参数，根据自己机器配置的实际情况分配locks和buffers;
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME informix_ids # Name of default database server
DBSERVERALIASES informix_ids_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
LOCKS 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
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
另外就是onconfig.cs文件中所有/usr/informix都替换成/home/informix/
5 初始化
oninit –ivy 再执行onstat –i
出现:
Informix Dynamic Server Version 9.40.UC1E1 -- On-Line -- Up 00:31:47 – 18872
安装成功
6增加数据库空间
onspaces –c –d blobdbs –p /home/informix/dbs/blobdbs –o 0 –s 100000
onspaces –c –d phydbs –p /home/informix/dbs/phydbs –o 0 –s 100000
onspaces –c –t –d tmpdbs –p /home/informix/dbs/tmpdbs –o 0 –s 100000
onspaces –c –d datadbs –p /home/informix/dbs/datadbs –o 0 –s 1000000
onspaces –c –d logdbs –p /home/informix/dbs/logdbs –o 0 –s 100000
如果想要datadbs开更大的空间执行:
onmode –BC 1 –y
onmode –s –y
执行80次:
onparams –a –d logdbs –s 10000
onmode –l
onmode –l
onmode –l
onmode –l
onmode –l
onmode –l
ontape –s –L 1 –y
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
onparams –p –s 90000 –d phydbs –y
onmode –ky
oninit
onstat –
onstat –d
onstat –l
|