AIX操作系统inix数据库安装实施文档OK.doc

华润万家AIX操作系统INFORMIX数据库安装实施文档华润万家有限公司信息部2008年03月15日版本信息文档信息文档名称华润万家AIX操作系统INFORMIX数据库安装实施文档部门信息部子部门文档类别安装文档文档子类别文档编号密级文档版本编号0.1文档版本日期2008年03月15日起草人高海洋起草日期2008年03月15日复核人章忠革复审日期2008年03月15日版本记录版本编号版 本 日 期修 改 者说 明文 件 名V0.12008年03月15日信息部安装文档华润万家AIX操作系统INFORMIX数据库安装实施文档.doc分发名单来 自From邮件地址日 期电 话/ 传 真信息部/高海洋gaohaiy2008年03月15日25685231给To 行 动*截 止 日 期电 话/ 传 真信息部/章忠革复核2008年03月15日25685080* 行动类别：批准，复核，通知，存档，所需行动，参加会议，其它（请指明）产权说明华润万家保留本文档所有权力。目 录一、关于本文41.1本文说明：41.2背景情况4二、机房环境要求（略）4三.操作系统安装准备（略）4四.操作系统安装（略）4五、数据库服务器的安装65.2 编辑.profile文件65.3 上传安装文件65.4安装IDS75.5建立连接（使用informix用户）125.6修改sqlhosts文件135.7修改配置文件135.8初始化数据库145.9数据库空间规划145.10建立数据chunk145.11初始化逻辑日志空间155.12修改informix配置文件165.13修改/home/informix/.profile文件175.14重新使用informix用户登录，再次启动数据库17基于AIX的Informix数据库安装实施文档一、关于本文1.1本文说明：针对北区大综超AIX操作系统上的informix数据库安装文档1.2背景情况主机型号:IBM 9406-595 主机操作系统：AIX 5.3数据库服务器：Informix 10.0.FC7数据库安装介质文件 IDS10.00_FC7_AIX_C13WHNA.tar二、机房环境要求（略）三.操作系统安装准备（略）四.操作系统安装（略）4.1增加相关配置（root用户）vi /etc/hosts-添加8 cms9901vi /etc/services -添加oncms9901 39001/tcp4.2建立cmsdatavg（root用户）使用smitty vg命令建立cmsdatavg。选择“Add a Volume Group”-“Add a Big Volume Group”在“VOLUME GROUP name”中填入vg名称“cmsdatavg”在“Physical partition SIZE in megabytes”中设置PP的大小为“128”在“PHYSICAL VOLUME names”中选择“hdisk2”，回车后弹出如下对话框：在Force the creation of a volume group? 选择为 YES+-+| ARE YOU SURE? | Continuing may delete information you may want | to keep. This is your last chance to stop | before continuing. | Press Enter to continue. | Press Cancel to return to the application. | F1=Help F2=Refresh F3=Cancel | Esc+8=Image Esc+0=Exit Enter=Do |+-+回车继续，当显示“Command: OK stdout: yes stderr: no”,VG建立成功。4.3创建裸设备（root用户）informix建议使用裸设备来管理，每个裸设备的大小为1G，建立命令如下：mklv -ylv_rootdbs -t raw -wn -sn -Llv_rootdbs cmsdatavg 8mklv -ylv_plogdbs -t raw -wn -sn -Llv_plogdbs cmsdatavg 8mklv -ylv_llogdbs -t raw -wn -sn -Llv_llogdbs cmsdatavg 8mklv -ylv_tmpdbs1 -t raw -wn -sn -Llv_tmpdbs1 cmsdatavg 8mklv -ylv_tmpdbs2 -t raw -wn -sn -Llv_tmpdbs2 cmsdatavg 8mklv -ylv_datachunk01 -t raw -wn -sn -Llv_datachunk01 cmsdatavg 8mklv -ylv_datachunk02 -t raw -wn -sn -Llv_datachunk02 cmsdatavg 8mklv -ylv_datachunk03 -t raw -wn -sn -Llv_datachunk03 cmsdatavg 8mklv -ylv_datachunk04 -t raw -wn -sn -Llv_datachunk04 cmsdatavg 8mklv -ylv_datachunk05 -t raw -wn -sn -Llv_datachunk05 cmsdatavg 8mklv -ylv_datachunk06 -t raw -wn -sn -Llv_datachunk06 cmsdatavg 8mklv -ylv_datachunk07 -t raw -wn -sn -Llv_datachunk07 cmsdatavg 8mklv -ylv_datachunk08 -t raw -wn -sn -Llv_datachunk08 cmsdatavg 8mklv -ylv_datachunk09 -t raw -wn -sn -Llv_datachunk09 cmsdatavg 8mklv -ylv_datachunk10 -t raw -wn -sn -Llv_datachunk10 cmsdatavg 8mklv -ylv_datachunk11 -t raw -wn -sn -Llv_datachunk11 cmsdatavg 8mklv -ylv_datachunk12 -t raw -wn -sn -Llv_datachunk12 cmsdatavg 8mklv -ylv_datachunk13 -t raw -wn -sn -Llv_datachunk13 cmsdatavg 8mklv -ylv_datachunk14 -t raw -wn -sn -Llv_datachunk14 cmsdatavg 8mklv -ylv_datachunk15 -t raw -wn -sn -Llv_datachunk15 cmsdatavg 8mklv -ylv_datachunk16 -t raw -wn -sn -Llv_datachunk16 cmsdatavg 8mklv -ylv_datachunk17 -t raw -wn -sn -Llv_datachunk17 cmsdatavg 8mklv -ylv_datachunk18 -t raw -wn -sn -Llv_datachunk18 cmsdatavg 8mklv -ylv_datachunk19 -t raw -wn -sn -Llv_datachunk19 cmsdatavg 8mklv -ylv_datachunk20 -t raw -wn -sn -Llv_datachunk20 cmsdatavg 8mklv -ylv_datachunk21 -t raw -wn -sn -Llv_datachunk21 cmsdatavg 8mklv -ylv_datachunk22 -t raw -wn -sn -Llv_datachunk22 cmsdatavg 8mklv -ylv_datachunk23 -t raw -wn -sn -Llv_datachunk23 cmsdatavg 8mklv -ylv_datachunk24 -t raw -wn -sn -Llv_datachunk24 cmsdatavg 8mklv -ylv_datachunk25 -t raw -wn -sn -Llv_datachunk25 cmsdatavg 8mklv -ylv_datachunk26 -t raw -wn -sn -Llv_datachunk26 cmsdatavg 8mklv -ylv_datachunk27 -t raw -wn -sn -Llv_datachunk27 cmsdatavg 8mklv -ylv_datachunk28 -t raw -wn -sn -Llv_datachunk28 cmsdatavg 8mklv -ylv_datachunk29 -t raw -wn -sn -Llv_datachunk29 cmsdatavg 8mklv -ylv_datachunk30 -t raw -wn -sn -Llv_datachunk30 cmsdatavg 8mklv -ylv_datachunk31 -t raw -wn -sn -Llv_datachunk31 cmsdatavg 8mklv -ylv_datachunk32 -t raw -wn -sn -Llv_datachunk32 cmsdatavg 8mklv -ylv_datachunk33 -t raw -wn -sn -Llv_datachunk33 cmsdatavg 8mklv -ylv_datachunk34 -t raw -wn -sn -Llv_datachunk34 cmsdatavg 8mklv -ylv_datachunk35 -t raw -wn -sn -Llv_datachunk35 cmsdatavg 8mklv -ylv_datachunk36 -t raw -wn -sn -Llv_datachunk36 cmsdatavg 8mklv -ylv_datachunk37 -t raw -wn -sn -Llv_datachunk37 cmsdatavg 8mklv -ylv_datachunk38 -t raw -wn -sn -Llv_datachunk38 cmsdatavg 8mklv -ylv_datachunk39 -t raw -wn -sn -Llv_datachunk39 cmsdatavg 8mklv -ylv_datachunk40 -t raw -wn -sn -Llv_datachunk40 cmsdatavg 84.4 建立数据库组、用户su - rootmkgroup id=2000 informixmkuser pgrp=informix home=/home/informix shell=/bin/ksh Informix建立连接文件夹：mkdir /oncms9901.links（根据实际需要修改成：“服务名.links”）chown informix:informix /oncms9901.links4.5对裸设备赋权chown informix:informix /dev/rlv_*chown informix:informix /dev/lv_*chmod 660 /dev/rlv_*chmod 660 /dev/lv_*4.6扩展文件系统chfs -a size=2G /tmpchfs -a size=5G /home五、数据库服务器的安装5.2 编辑.profile文件vi /home/informix/.profile文件加上如下语句：INFORMIXDIR=/home/informix -informix安装目录INFORMIXSERVER=oncms9901 -服务名PATH=$PATH:$INFORMIXDIR/bin -搜索路径ONCONFIG=oncms9901.cfg -配置文件export INFORMIXDIR INFORMIXSERVER ONCONFIG PATHexport PS1=$INFORMIXSERVER:$PWD5.3 上传安装文件使用informix用户，将informix安装包IDS10.00_FC7_AIX_C13WHNA.tar用二进制上传到/tmp/setup目录下。解包：tar xvf IDS10.00_FC7_AIX_C13WHNA.tar5.4安装IDS使用root用户，进入/tmp/setup目录，执行./ids_install# ./ ids_install Initializing InstallShield Wizard. Verifying JVM. Launching InstallShield Wizard. 1. Release Notes 2. Quick Beginnings Guide 3. Begin InstallationPlease select one of these options 3 3Beginning installation.Press 1 for Next, 3 to Cancel or 4 to Redisplay 1 1Welcome to the InstallShield Wizard for IBM Informix Dynamic Server BundleThe InstallShield Wizard will install IBM Informix Dynamic Server Bundle onyour computer.To continue, choose Next.Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay 1 1 International Program License Agreement Part 1 - General Terms BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, OR USING THE PROGRAM YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE TERMS ON BEHALF OF ANOTHER PERSON OR A COMPANY OR OTHER LEGAL ENTITY, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL AUTHORITY TO BIND THAT PERSON, COMPANY, OR LEGAL ENTITY TO THESE TERMS. IF YOU DO NOT AGREE TO THESE TERMS, - DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, OR USE THE PROGRAM; AND - PROMPTLY RETURN THE PROGRAM AND PROOF OF ENTITLEMENT TO THE PARTYPress Enter to continue viewing the license agreement, or, Enter 1 to accept the agreement, 2 to decline it or 99 to go back to the previous screen, 3 Print, 4 Read non-IBM terms.1Press 1 for Next, 3 to Cancel or 4 to Redisplay 1 1IBM Informix Dynamic Server Bundle Install LocationPlease specify a directory or press Enter to accept the default directory.Directory Name: /opt/IBM/informix /home/informixPress 1 for Next, 3 to Cancel or 4 to Redisplay 1 1Searching for products available for install: this may take a few minutes.Select the products you would like to install: To select/deselect a product or to change its setup type, type its number: Product Setup Type - - 1. IBM Informix IConnect 2. x IBM Informix Client-SDK Typical 3. x IBM Informix Dynamic Server Typical 4. x IBM Informix JDBC Driver Version 3.10 Other options: 0. Continue installing Enter command 0 0Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay 1 1Do you want to enable role separation? 1 - YesX 2 - NoTo select an item enter its number, or 0 when you are finished: 0 0Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay 1 1Would you like to create an IDS demo instance? 1 - Create DemoX 2 - Do Not Create DemoTo select an item enter its number, or 0 when you are finished: 0 0The primary purpose of the demo instance is to ensure that the product isproperly installed and the hardware is configured to work with IDS.This demo instance can be used as an actual production instance if properlyconfigured.Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay 1 1IBM Informix Dynamic Server Bundle will be installed in the following location:/home/informixwith the following features:IBM Informix Client-SDKIBM Informix Dynamic ServerIBM Informix JDBC Driver Version 3.10for a total size: 448.4 MBPress 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay 1 1Installing IBM Informix Client-SDK. Please wait.0 % complete10 % complete20 % complete30 % complete40 % complete50 % complete60 % complete70 % complete80 % complete90 % complete100 % completeUpdating the inventory . Creating uninstaller.Installing IBM Informix Dynamic Server. Please wait.Updating the inventory . Creating uninstaller.Installing IBM Informix JDBC Driver Version 3.10. Please wait.Creating uninstaller.Branding Files .Installing directory .Installing directory etcInstalling directory binInstalling directory libInstalling directory lib/clientInstalling directory lib/client/csmInstalling directory lib/esqlInstalling directory lib/dmiInstalling directory lib/c+Installing directory lib/cliInstalling directory releaseInstalling directory release/en_usInstalling directory release/en_us/0333Installing directory inclInstalling directory incl/esqlInstalling directory incl/dmiInstalling directory incl/c+Installing directory incl/cliInstalling directory demoInstalling directory demo/esqlcInstalling directory demo/c+Installing directory demo/cliInstalling directory docInstalling directory doc/gls_apiInstalling directory doc/gls_api/en_usInstalling directory doc/gls_api/en_us/0333IBM Informix Product: IBM INFORMIX-Client SDKInstallation Directory: /home/informixPerforming root portion of installation of IBM INFORMIX-Client SDK.Installation of IBM INFORMIX-Client SDK complete.Installing directory etcInstalling directory glsInstalling directory gls/cm3Installing directory gls/cv9Installing directory gls/dllInstalling directory gls/etcInstalling directory gls/lc11Installing directory gls/lc11/cs_czInstalling directory gls/lc11/da_dkInstalling directory gls/lc11/de_atInstalling directory gls/lc11/de_chInstalling directory gls/lc11/de_deInstalling directory gls/lc11/en_auInstalling directory gls/lc11/en_gbInstalling directory gls/lc11/en_usInstalling directory gls/lc11/es_esInstalling directory gls/lc11/fi_fiInstalling directory gls/lc11/fr_beInstalling directory gls/lc11/fr_caInstalling directory gls/lc11/fr_chInstalling directory gls/lc11/fr_frInstalling directory gls/lc11/is_isInstalling directory gls/lc11/it_itInstalling directory gls/lc11/ja_jpInstalling directory gls/lc11/ko_krInstalling directory gls/lc11/nl_beInstalling directory gls/lc11/nl_nlInstalling directory gls/lc11/no_noInstalling directory gls/lc11/osInstalling directory gls/lc11/pl_plInstalling directory gls/lc11/pt_brInstalling directory gls/lc11/pt_ptInstalling directory gls/lc11/ru_ruInstalling directory gls/lc11/sk_skInstalling directory gls/lc11/sv_seInstalling directory gls/lc11/th_thInstalling directory gls/lc11/zh_cnInstalling directory gls/lc11/zh_twIBM Informix Product: GlsInstallation Directory: /home/informixPerforming root portion of installation of Gls.Installation of Gls complete.Installing directory etcInstalling directory msgInstalling directory msg/en_usInstalling directory msg/en_us/0333IBM Informix Product: messagesInstallation Directory: /home/informixPerforming root portion of installation of messages.Installation of messages complete.Branding Installed Files .Please read the information below.Set required environment variables Set $INFORMIXDIR to the directory where the IDS server is installed. Set $PATH to include $INFORMIXDIR/bin Set oncms9901 to the name of the database server Set $ONCONFIG to the name of the active onconfig configuration file. If using a sqlhosts file other than $INFORMIXDIR/etc/sqlhosts Set $INFORMIXSQLHOSTS If using a locale/language other than the default Set $CLIENT_LOCALE Set $DB_LOCALE Set $SERVER_LOCALE Set $DBLANGPrepare connectivity files sqlhosts /etc/hosts /etc/servicesPrepare configuration file Set DBSERVERNAME Set SERVERNUM Set ROOTNAMEPress ENTER to read the text Type q to quit Set ROOTPATH Set ROOTSIZE Initialize database server As informix or root, run oninit If initializing a new server for the FIRST time, run oninit -iThis will overwrite any existing data, so use caution on an existing setupFor more information please refer to the IBM Informix Dynamic Server Getting Started GuidePress 1 for Next, 3 to Cancel or 4 to Redisplay 1 1The InstallShield Wizard has successfully installed IBM Informix Dynamic ServerBundle. Choose Next to continue the wizard.Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay 1 1 1. Release Notes 2. Installation Guide 3. Finish InstallationPlease select one of these options 3 3Finishing Installation.Press 3 to Finish or 4 to Redisplay 3 3#5.5建立连接（使用informix用户）su - informixcd /oncms9901.linksln -s /dev/rlv_rootdbs /oncms9901.links/rootdbsln -s /dev/rlv_plogdbs /oncms9901.links/plogdbsln -s /dev/rlv_llogdbs /oncms9901.links/llogdbsln -s /dev/rlv_tmpdbs1 /oncms9901.links/tmpdbs1ln -s /dev/rlv_tmpdbs2 /oncms9901.links/tmpdbs2ln -s /dev/rlv_datachunk01 /oncms9901.links/datachunk01ln -s /dev/rlv_datachunk02 /oncms9901.links/datachunk02ln -s /dev/rlv_datachunk03 /oncms9901.links/datachunk03ln -s /dev/rlv_datachunk04 /oncms9901.links/datachunk04ln -s /dev/rlv_datachunk05 /oncms9901.links/datachunk05ln -s /dev/rlv_datachunk06 /oncms9901.links/datachunk06ln -s /dev/rlv_datachunk07 /oncms9901.links/datachunk07ln -s /dev/rlv_datachunk08 /oncms9901.links/datachunk08ln -s /dev/rlv_datachunk09 /oncms9901.links/datachunk09ln -s /dev/rlv_datachunk10 /oncms9901.links/datachunk10ln -s /dev/rlv_datachunk11 /oncms9901.links/datachunk11ln -s /dev/rlv_datachunk12 /oncms9901.links/datachunk12ln -s /dev/rlv_datachunk13 /oncms9901.links/datachunk13ln -s /dev/rlv_datachunk14 /oncms9901.links/datachunk14ln -s /dev/rlv_datachunk15 /oncms9901.links/datachunk15ln -s /dev/rlv_datachunk16 /oncms9901.links/datachunk16ln -s /dev/rlv_datachunk17 /oncms9901.links/datachunk17ln -s /dev/rlv_datachunk18 /oncms9901.links/datachunk18ln -s /dev/rlv_datachunk19 /oncms9901.links/datachunk19ln -s /dev/rlv_datachunk20 /oncms9901.links/datachunk20ln -s /dev/rlv_datachunk21 /oncms9901.links/datachunk21ln -s /dev/rlv_datachunk22 /oncms9901.links/datachunk22ln -s /dev/rlv_datachunk23 /oncms9901.links/datachunk23ln -s /dev/rlv_datachunk24 /oncms9901.links/datachunk24ln -s /dev/rlv_datachunk25 /oncms9901.links/datachunk25ln -s /dev/rlv_datachunk26 /oncms9901.links/datachunk26ln -s /dev/rlv_datachunk27 /oncms9901.links/datachunk27ln -s /dev/rlv_datachunk28 /oncms9901.links/datachunk28ln -s /dev/rlv_datachunk29 /oncms9901.links/datachunk29ln -s /dev/rlv_datachunk30 /oncms9901.links/datachunk30ln -s /dev/rlv_datachunk31 /oncms9901.links/datachunk31ln -s /dev/rlv_datachunk32 /oncms9901.links/datachunk32ln -s /dev/rlv_datachunk33 /oncms9901.links/datachunk33ln -s /dev/rlv_datachunk34 /oncms9901.links/datachunk34ln -s /dev/rlv_datachunk35 /oncms9901.links/datachunk35ln -s /dev/rlv_datachunk36 /oncms9901.links/datachunk36ln -s /dev/rlv_datachunk37 /oncms9901.links/datachunk37ln -s /dev/rlv_datachunk38 /oncms9901.links/datachunk38ln -s /dev/rlv_datachunk39 /o