informix数据库产品安装

1、1 informix数据库产品安装1.1 数据库用户的环境变量本数据库系统对于操作系统的参数无特殊需求以informix用户登陆主机, 将下述环境变量加入informix用户的.profile文件中INFORMIXDIR=/home/db/informixPATH=$INFORMIXDIR/bin:$PATHINFORMIXSERVER= atmpdbONCONFIG=onconfig. atmpdbTERMCAP=$INFORMIXDIR/etc/termcapTERM=vt100LIBPATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/cli:$INFORMIXD

2、IR/lib/esql:$LIBPATHSHLIB_PATH=$LIBPATHLD_LIBRARY_PATH=$LIBPATHexport INFORMIXDIR PATH INFORMIXSERVER ONCONFIG TERMCAP TERM LIBPATH LD_LIBRARY_PATH SHLIB_PATH退出登录，并重新登录，使参数信息生效。1.2 数据库的安装1载入安装文件以informix用户登陆主机将当前目录设置为$INFORMIXDIR:$cd $INFORMIXDIR载入安装文件，用informix用户身份执行：根据产品介质的文件格式，使用cpio或tar命令: #cpio

3、 -icvmduB < /path/filename.cpio或 tar xvf /path/filename.tar2安装数据库系统以informix用户在/home/db/informix下执行以下命令$ su # ./ids_installWARNING! This software, and its authorized use and number of users, aresubject to the applicable license agreement with IBM Corporation.If the number of users exceeds the lic

4、ensed number, the excess users maybe prevented from using the software. UNAUTHORIZED USE OR COPYING MAYSUBJECT YOU AND YOUR COMPANY TO SEVERE CIVIL AND CRIMINAL LIABILITIES.Please Press RETURN to Continue, or (q/Q) to Quit :IBM Informix Unix Bundle InstallerInstallation Requirements:- A user "i

5、nformix" and a group "informix" must be known to the system.- This installation procedure must be run by user root.- Approximately 770 MB disk space required initially.- Approximately 500 MB disk space if everything is installed (50 MB for ISA, 25 MB for either version of JDBC).0) All

6、 Products listed below1) IBM Informix Dynamic Server 9.402) IBM Informix IConnect3) IBM Informix JDBC version 2.214) IBM Informix Server Administrator5) Configure a Demo IDS Server (requires IDS)Enter the number(s) of the products to install, separated by spaces(i.e. "1 2 3"):1 （选择1）Instal

7、l into directory (INFORMIXDIR) /home/db/informix : （直接回车）Installing IBM Informix Dynamic Server 9.40420050 blocks5260 blocks80360 blocks334300 blocksBundle Install program has finished# ./RUN_AS_ROOT.server （以root用户执行post script）Informix Product: IBM Informix Dynamic ServerInstallation Directory: /h

8、ome/db/informixPerforming root portion of installation of IBM Informix Dynamic Server .Installation of IBM Informix Dynamic Server complete.数据库系统安装完毕。1.3 CSDK安装$ ./installclientsdkIBM/Informix-Client SDK Version 2.81.FC2Copyright (C) 1991-2002 IBMIs ClientSDK being installed along with Informix data

9、base serverversion 9.x (required to be run as user "informix")?(yes or no)yInstallation ScriptInstallation Script Requirements:- A user "informix" and a group "informix" must be known to the system.- The product source files must have been loaded by user informix- This

10、installation procedure must be run by user informix.- You must also set INFORMIXDIR to where you would like to install- the product on and make INFORMIXDIR as your current working directory.This script will change the owner, group, and mode ofmany of the files of this package in this directory.Extra

11、cting files from clientsdkcontent file.*To complete the installation of INFORMIX-Client SDK,run /home/db/informix/RUN_AS_ROOT.clientsdk as root.*Informix user portion of installation of INFORMIX-Client SDK complete.# ./RUN_AS_ROOT.clientsdkInformix Product: INFORMIX-Client SDKInstallation Directory:

12、 /home/db/informixPerforming root portion of installation of INFORMIX-Client SDK.Installation of INFORMIX-Client SDK complete.1.4 安装后设置准备数据库server用onconfig文件和修改sqlhosts确认数据库用的设备文件和链接文件均权限和属主正确，即/dev下和INFORMIXDIR/atmpdbs下的链接文件。以informix用户注册，进入etc目录，执行$cp onconfig.std onconfig.atmpdb调整informix数据库配置参数：

13、编辑onconfig.atmpdb，参数设置参见详细设计。编辑sqlhosts文件，参数设置参见详细设计。编辑/etc/services文件，参数设置参见详细设计。1.5 创建数据库以informix用户登录，执行$oninit ivy或者执行onmonitorparametersinitialize进入初始化配置界面。执行$onstat m查看日志，当sysmaster database built successfully 时，表明系统初始化结束，此时数据库状态为静态Quiescent。2创建空间创建逻辑日志、物理日志、数据及索引所用的空间： 1).使用以下命令行建立： $onmode -

14、BC 1 / 支持大文件 $ onspaces c -d phydbs -p /home/db/informix/atmpdbs/ phychunk -o 0 -s 2044000 /建立物理日志$ onspaces -c -d logdbs -p /home/db/informix/atmpdbs/ logchunk -o 0 -s 2044000 /建立逻辑日志$ onspaces -c -d tempdbs0 -t p /home/db/informix/atmpdbs/ tmpchunk0 -o 0 -s 2044000 /建立tempdbs0$ onspaces -c -d temp

15、dbs1 -t p /home/db/informix/atmpdbs/ tmpchunk1 -o 0 -s 2044000 /建立tempdbs1建立数据存储空间 大型系统如下：$ onspaces -c d datadbs -p /home/db/informix/atmpdbs/datachunk0 -o 0 -s 5117000 $ onspaces a datadbs -p /home/db/informix/atmpdbs/datachunk1 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/dat

16、achunk2 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk3 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk4 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk5 -o 0 -s 5117000$ onspaces -c datadbs -p /home/db/informix/atm

17、pdbs/datachunk6 -o 0 -s 5117000 $ onspaces a datadbs -p /home/db/informix/atmpdbs/datachunk7 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk8 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk9 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/info

18、rmix/atmpdbs/datachunk10 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk11 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk12 -o 0 -s 5117000所有的dbs都创建完毕.可以使用$onstat d查看创建情况中型系统如下：$ onspaces -c d datadbs -p /home/db/informix/atmpdbs/datachunk0 -o

19、 0 -s 5117000 $ onspaces a datadbs -p /home/db/informix/atmpdbs/datachunk1 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk2 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk3 -o 0 -s 5117000$ onspaces a datadbs -p /home/db/informix/atmpdbs/datach

20、unk4 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk5-o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/datachunk6 -o 0 -s 5117000$ onspaces a datadbs -p /home/db/informix/atmpdbs/datachunk7 -o 0 -s 5117000$ onspaces -a datadbs -p /home/db/informix/atmpdbs/

21、datachunk8 -o 0 -s 5117000所有的dbs都创建完毕.可以使用$onstat d查看创建情况。小型系统如下：$ onspaces -c d datadbs -p /home/db/informix/atmpdbs/datachunk0 -o 0 -s 5117000 $ onspaces a datadbs -p /home/db/informix/atmpdbs/datachunk1 -o 0 -s 5117000$ onspaces a datadbs -p /home/db/informix/atmpdbs/datachunk2 -o 0 -s 5117000$ o

22、nspaces a datadbs -p /home/db/informix/atmpdbs/datachunk3 -o 0 -s 5117000$ onspaces a datadbs -p /home/db/informix/atmpdbs/datachunk4 -o 0 -s 5117000所有的dbs都创建完毕.可以使用$onstat d查看创建情况。3. 改变逻辑日志和物理日志的位置，大小和个数： 1)在logdbs上划分40个50M的逻辑日志 $ onparams -a -d logdbs -s 50000 将上一条命令执行40次共40个逻辑日志$onmode l（当前日志下移）$

23、onmode l（当前日志下移）$onmode l（当前日志下移）$ontape s L 0$onparams d l 1 y$onparams d l 2 -y$onparams d l 2 -y2） 修改状态为静止状态 $ onmode -s3） 将物理日志从缺省的rootdbs上移到phydbs上 $ onparams -p -d phydbs -s 1990000$onmode m /恢复联机状态2 TUXEDO安装2.1 建立用户组组名IDuserstuxedo301tuxedo命令：mkgroup -A id=301 users=root tuxedo2.2 建立用户用户名IDPrimary groupGroup SETHome direcyorytuxedo300tuxedotuxedo/home/tuxedo命令：mkuser -A id=300 pgrp=tuxedo home=/home/tuxedo tuxedo2.3 tuxedo9.0系统空间要求磁盘空间要求：Full install163,752 KBTemporary space for installer179,204 KB3 Tux