IBM Informix Dynamic Server (IDS) V10.0 FC1 for Solaris Sparc (64-bit)安装

redwaves

环境说明:
1.SUN Sparc主机
2.Solaris 9 64bit
3.IP地址:192.168.0.99
4.hostname:sun99

一、创建用户和组
1.login as user root
2.使用groupadd创建一个informix组
#groupadd -g 102 imformix
3.使用useradd 创建一个informix用户
#useradd -u 1100 -g 102 -d /export/home/informix -m -s /bin/sh informix
4.为informix帐户设置密码
#passwd informix
二.修改系统配置文件
1.在/etc/system文件末尾添加：
set enable_sm_wa = 1
set shmsys:shminfo_shmmax=268435456
set semsys:seminfo_semmap=64
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=64
set semsys:seminfo_semmsl=100
set shmsys:shminfo_shmmin=100
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=100

2.在/etc 下创建hosts.equiv文件,并写入
192.168.0.99 sun99

3.编辑/etc/services文件,增加
sqlexec 8765/tcp #infromix服务端口

4.创建.profile文件
#cp /etc/skel/.profile /export/home/informix/.profile
5.在.profile文件中添加如下行：
INFORMIXDIR=/export/home/informix  #informix安装目录
INFORMIXSERVER=sun99   #informix实例名,可以自已定义
ONCONFIG=onconfig.sun99  #若前一项实例名为自已定义,此处的.sun99作相应变更
export INFORMIXDIR INFORMIXSERVER ONCONFIG

6.在PATH=/usr/bin:/usr/ucb:/etc:.中增加/export/home/informix/bin:
PATH=/usr/bin:/usr/ucb:/etc:/export/home/informix/bin:.
export PATH

7.重新启动操作系统
#sync
#reboot

三、安装IDS:
1.login as user root
2.mount cdrom
3.执行./ids_install -gui  #以图形界面方式启动安装
4.选择接受许可协议
5.点击"NEXT"
6.指定安装目录为前面设置的/export/home/informix
7.其他项均选默认项(除不选创建Demo数据库)

四、配置通信服务和创建数据库
1、login as user root

2、su - informix

3、创建rootdbs的chunk:
在/export/home/informix目录下创建Data目录存放chunk文件：
$cd /export/home/informix
$mkdir Data
$touch rootdbs
$chmod 660 rootdbs

4.修改rootdbs的所有权
#cd /export/home/informix/Data
#chown informix:informix rootdbs

5.创建通信配置文件:
copy一份配置模板为当前sqlhosts文件:
#cd /export/home/informix/etc
#cp sqlhosts.std sqlhosts
#echo "sun99 ontlitcp sun99 sqlexec">>/export/home/informix/etc/sqlhosts #在sqlhosts文件中末尾加入下面一行sun99 ontlitcp sun99 sqlexec

6.创建onconfig.server配置文件:
#cd /export/home/informix/etc
#cp onconfig.std onconfig.sun99
#chown informix:informix onconfig.sun99 #修改onconfig.sun99文件的所有权

7.使用vi修改onconfig.sun99文件如下项为：
ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /export/home/informix/Data/rootdbs # Path for device containing root dbspace
DBSERVERNAME  sun99

8.将onconfig.sun99中所有的/usr/informix项修改为/export/home/informix

五、初始化数据库
1、login as user root

2、su - informix

3、使用以下命令初始化数据库
$oninit -ivy
以下为创建示例：
$ oninit -ivy
Checking group membership to determine server run mode...succeeded
Reading configuration file '/export/home/informix/etc/onconfig.sun99'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Creating infos file "/export/home/informix/etc/.infos.sun99"...succeeded
Linking conf file "/export/home/informix/etc/.conf.sun99"...succeeded
Writing to infos file...succeeded
Checking config parameters...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 1438 kbytes...succeeded
Allocating 18384 kbytes for buffer pool of 2K page size...succeeded
Initializing rhead structure...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...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...succeeded
Forking 1 'tlitcp' listener threads...succeeded
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
Forking btree cleaner...succeeded
Initializing DBSPACETEMP list...succeeded
Checking database partition index...succeeded
Checking location of physical log...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Forking onmode_mon thread...succeeded
Verbose output complete: mode = 5
$

     注：如果创建失败请查看/export/home/informix/online.log查找原因。一般情况下为
/etc/system ;
/etc/hosts;
/etc/hosts.equiv ;
/export/home/informix/.profile;
/etc/services;
/export/home/informix/etc/onconfig.sun99
/export/home/informix/etc/sqlhosts
文件的置配问题。

4、使用onstat -i 查看数据是否启动：
$ onstat -i

IBM Informix Dynamic Server Version 10.00.FC1     -- On-Line -- Up 00:07:00 -- 29696 Kbytes
onstat>
   以上说明了IDS 10已启动

5.停止数据库
$onmode -ky

6.启动数据库
$oninit


至此一个基本的IDS环境已完成。

六、informix数据库及其存储
使用文件形式来创建informix-chunk存储数据，在chunk基础上是逻辑概念的dbspace，他们是多对多的关系，我们创建数据库是直接指定在dbs上创建，并不指定在chunk上创建

1、创建chunk
$cd /export/home/informix/Data
$touch userdbs test01dbs test02dbs test03dbs tempdbs logiclogdbs phylogdbs mirroruserdbs mirrorrootdbs mirrortest01dbs mirrortest02dbs mirrortest03dbs mirrorlogiclogdbs mirrorphylogdbs

2.修改权限
$chmod 660 userdbs test01dbs test02dbs test03dbs tempdbs logiclogdbs phylogdbs mirroruserdbs mirrorrootdbs mirrortest01dbs mirrortest02dbs mirrortest03dbs mirrorlogiclogdbs mirrorphylogdbs
#chown informix:informix userdbs test01dbs test02dbs test03dbs tempdbs logiclogdbs phylogdbs mirroruserdbs mirrorrootdbs mirrortest01dbs mirrortest02dbs mirrortest03dbs mirrorlogiclogdbs mirrorphylogdbs

3.创建userdbs;testdbs;tempdbs;logiclogdbs;phylogdbs
$onspaces -c -d userdbs -p /export/home/informix/Data/userdbs -o 0 -s 10240
$onspaces -c -d testdbs -p /export/home/informix/Data/test01dbs -o 0 -s 10240
$onspaces -a testdbs -p /export/home/informix/Data/test02dbs -o 0 -s 10240
$onspaces -a testdbs -p /export/home/informix/Data/test03dbs -o 0 -s 10240
$onspaces -c -d tempdbs -t -p /export/home/informix/Data/tempdbs -o 0 -s 10240
$onspaces -c -d logiclogdbs -p /export/home/informix/Data/logiclogdbs -o 0 -s 10240
$onspaces -c -d phylogdbs -p /export/home/informix/Data/phylogdbs -o 0 -s 10240

4.镜象userdbs;testdbs;logiclogdbs;phylogdbs;rootdbs
$onspaces -m userdbs -p /export/home/informix/Data/userdbs -o 0 -m /export/home/informix/Data/mirroruserdbs 0
$onspaces -m testdbs -p /export/home/informix/Data/test01dbs -o 0 -m /export/home/informix/Data/mirrortest01dbs 0
$onspaces -m testdbs -p /export/home/informix/Data/test02dbs -o 0 -m /export/home/informix/Data/mirrortest02dbs 0
$onspaces -m testdbs -p /export/home/informix/Data/test03dbs -o 0 -m /export/home/informix/Data/mirrortest03dbs 0
$onspaces -m logiclogdbs -p /export/home/informix/Data/logiclogdbs -o 0 -m /export/home/informix/Data/mirrorlogiclogdbs 0
$onspaces -m phylogdbs -p /export/home/informix/Data/phylogdbs -o 0 -m /export/home/informix/Data/mirrorphylogdbs 0
$onspaces -m rootdbs -p /export/home/informix/Data/rootdbs -o 0 -m /export/home/informix/Data/mirrorrootdbs 0

5.删除testdbs的镜像
$onspaces -r testdbs
$rm mirrortest*dbs

6.删除testdbs
$onspaces -d testdbs -p /export/home/informix/Data/test03dbs -o 0
$onspaces -d testdbs -p /export/home/informix/Data/test02dbs -o 0

7.创建数据库
create database sun99 in userdbs;
close database;
drop database sun99;

8.检查数据库中的chunk空闲情况
$onstat -d

[ 本帖最后由 redwaves 于 2007-9-11 15:49 编辑 ]

candleinwind

very good!

shanshl

不错，看一下，