informix數(shù)據(jù)庫產(chǎn)品安裝

1、1 informix數(shù)據(jù)庫產(chǎn)品安裝1.1 數(shù)據(jù)庫用戶的環(huán)境變量本數(shù)據(jù)庫系統(tǒng)對于操作系統(tǒng)的參數(shù)無特殊需求以informix用戶登陸主機(jī), 將下述環(huán)境變量加入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退出登錄，并重新登錄，使參數(shù)信息生效。1.2 數(shù)據(jù)庫的安裝1載入安裝文件以informix用戶登陸主機(jī)將當(dāng)前目錄設(shè)置為$INFORMIXDIR:$cd $INFORMIXDIR載入安裝文件，用informix用戶身份執(zhí)行：根據(jù)產(chǎn)品介質(zhì)的文件格式，使用cpio或tar命令: #cpio

3、 -icvmduB < /path/filename.cpio或 tar xvf /path/filename.tar2安裝數(shù)據(jù)庫系統(tǒng)以informix用戶在/home/db/informix下執(zhí)行以下命令$ 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用戶執(zhí)行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.數(shù)據(jù)庫系統(tǒng)安裝完畢。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 安裝后設(shè)置準(zhǔn)備數(shù)據(jù)庫server用onconfig文件和修改sqlhosts確認(rèn)數(shù)據(jù)庫用的設(shè)備文件和鏈接文件均權(quán)限和屬主正確，即/dev下和INFORMIXDIR/atmpdbs下的鏈接文件。以informix用戶注冊，進(jìn)入etc目錄，執(zhí)行$cp onconfig.std onconfig.atmpdb調(diào)整informix數(shù)據(jù)庫配置參數(shù)：

13、編輯onconfig.atmpdb，參數(shù)設(shè)置參見詳細(xì)設(shè)計(jì)。編輯sqlhosts文件，參數(shù)設(shè)置參見詳細(xì)設(shè)計(jì)。編輯/etc/services文件，參數(shù)設(shè)置參見詳細(xì)設(shè)計(jì)。1.5 創(chuàng)建數(shù)據(jù)庫以informix用戶登錄，執(zhí)行$oninit ivy或者執(zhí)行onmonitorparametersinitialize進(jìn)入初始化配置界面。執(zhí)行$onstat m查看日志，當(dāng)sysmaster database built successfully 時(shí)，表明系統(tǒng)初始化結(jié)束，此時(shí)數(shù)據(jù)庫狀態(tài)為靜態(tài)Quiescent。2創(chuàng)建空間創(chuàng)建邏輯日志、物理日志、數(shù)據(jù)及索引所用的空間： 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建立數(shù)據(jù)存儲空間 大型系統(tǒng)如下：$ 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都創(chuàng)建完畢.可以使用$onstat d查看創(chuàng)建情況中型系統(tǒng)如下：$ 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都創(chuàng)建完畢.可以使用$onstat d查看創(chuàng)建情況。小型系統(tǒng)如下：$ 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都創(chuàng)建完畢.可以使用$onstat d查看創(chuàng)建情況。3. 改變邏輯日志和物理日志的位置，大小和個(gè)數(shù)： 1)在logdbs上劃分40個(gè)50M的邏輯日志 $ onparams -a -d logdbs -s 50000 將上一條命令執(zhí)行40次共40個(gè)邏輯日志$onmode l（當(dāng)前日志下移）$

23、onmode l（當(dāng)前日志下移）$onmode l（當(dāng)前日志下移）$ontape s L 0$onparams d l 1 y$onparams d l 2 -y$onparams d l 2 -y2） 修改狀態(tài)為靜止?fàn)顟B(tài) $ onmode -s3） 將物理日志從缺省的rootdbs上移到phydbs上 $ onparams -p -d phydbs -s 1990000$onmode m /恢復(fù)聯(lián)機(jī)狀態(tài)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系統(tǒng)空間要求磁盤空間要求：Full install163,752 KBTemporary space for installer179,204 KB3 Tux