富士通db2双机安装手册.doc

双机安装手册安装目标：数据库db2与应用web进行双机互备。安装的软件：需要solaris 10下安装：DB2、WAS中间件、东方通中间件.DB2版本：9.1.5WAS中间件版本：6.1打上6.1.0.11的补丁东方通中间件版本：tongweb 4.6环境：双机：A机m8000-p3 B机m8000-p2准备工作：解压缩 *.gz-gunzip *.gz *.zip-unzip *.zip*.tar-tar xvf *.tar修改操作系统参数/etc/system set rlim_fd_max=16384 set rlim_fd_cur=16384 set sq_max_size=0 set tcp:tcp_conn_hash_size=8192创建操作系统用户：A机/usr/sbin/groupadd -g 200 db2iadm1 /usr/sbin/groupadd -g 201 db2fadm1 /usr/sbin/useradd -u 200 -m -g db2iadm1 -d /opt/db2inst1 db2inst1/usr/sbin/useradd -u 201 -m -g db2fadm1 -d /opt/db2fenc1 db2fenc1B机/usr/sbin/groupadd -g 200 db2iadm1 /usr/sbin/groupadd -g 201 db2fadm1 /usr/sbin/useradd -u 200 -m -g db2iadm1 -d /opt/db2inst1 db2inst1/usr/sbin/useradd -u 201 -m -g db2fadm1 -d /opt/db2fenc1 db2fenc1修改操作系统用户密码：passwd db2inst1两边的instance用户和fence用户的主目录都在本地注意：两台机的instance用户和fence用户的ID号和组的ID号都要一样。实例名：db2inst1数据库：bz/yq配置过程：1、共享存储：db2/data1/data2/data3/databack均已建立,双机切换时只需mount即可。2、安装DB2 解压DB2包，执行./db2_install,根据提示建立DB2安装文件夹。bash-3.00# ./db2_install Default directory for installation of products - /opt/IBM/db2/V9.1*Do you want to choose a different directory to install yes/no ?no Specify one of the following keywords to install DB2 products. CLIENT RTCL ESE Enter help to redisplay product names.Enter quit to exit.*EseTask #1 startDescription: Checking license agreement acceptanceEstimated time 1 second(s)Task #1 endTask #43 startDescription: Updating global profile registryEstimated time 3 second(s)Task #43 endThe execution completed successfully.For more information see the DB2 installation log at /tmp/db2_install.log.26173.安装完成修改系统参数要使用 db2osconf 命令，必须首先安装 DB2 数据库系统。只能从 $DB2DIR/bin 中运行 db2osconf 实用程序，其中 $DB2DIR 是 DB2 产品的安装目录。要设置内核参数，请在 /etc/system 文件末尾添加以下行： 例如：set msgsys:msginfo_msgmni = 10240set semsys:seminfo_semmni = 12288set shmsys:shminfo_shmmax = 61811409715set shmsys:shminfo_shmmni = 122883、创建实例：在/opt/IBM/db2/V9.1/instance/目录下，执行 ./db2icrt -a server -u db2fenc1 db2inst1即DB2数据库实例名为db2inst15、添加DB2端口su - rootvi /etc/services 加入下面一行 db2inst1 50000/tcp两台机器端口号要一样。6、产品许可证 /opt/IBM/db2/V8.1/adm/db2licm -a /mnt/cdrom/db2/license/db2pe.licdb2pe.lic位置根据实际情况决定。目录授权 chown db2inst1:db2iadm1 /data17、DB2 配置 su - db2inst1 db2set DB2_SKIPINSERTED=YESdb2set DB2_EVALUNCOMMITTED=ondb2set DB2COMM=tcpipdb2set DB2CODEPAGE=1386db2set db2_parallel_io=* 可以使用db2set查看。8、Update dbm cfg db2 update dbm cfg using SVCENAME db2inst1 db2 update dbm cfg using INDEXREC ACCESSdb2startDB2安装结束，需要用同样的方法在两台机器上分别执行安装。9、创建数据库并实现双机切换目录授权 chown db2inst1:db2iadm1 /data1先在A机上创建：修改数据库实例密码：passwd db2inst1为db2inst1Su - db2inst1在bash下执行db2 “CREATE DATABASE bz ON /db2 USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM CATALOG TABLESPACE MANAGED BY DATABASE USING ( FILE /db2/bz/Catalogdata1 128000 ) USER TABLESPACE MANAGED BY DATABASE USING ( FILE /db2/bz/Userdata1 512000 ) TEMPORARY TABLESPACE MANAGED BY DATABASE USING ( FILE /data1/bz/Tempspace1 768000)”在DATA1卷组中可以看到一个bz的数据文件夹和一个bz数据库文件夹。db2 connect to bz user db2inst1 using db2inst1连接成功。断开DB2连接，db2stop force 断开所有和A机上DB2的连接，先将data1中bz的数据文件夹和实例文件夹重命名Mv bz bz1Mv db2inst1 db2inst11在/目录下，执行umount /data1目录授权 chown db2inst1:db2iadm1 /data1切换到B机上，执行mount /data1将data1卷组挂接到B机上在B机上启动DB2实例db2inst1，同样执行db2 “CREATE DATABASE bz ON /db2 USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM CATALOG TABLESPACE MANAGED BY DATABASE USING ( FILE /db2/bz/Catalogdata1 128000 ) USER TABLESPACE MANAGED BY DATABASE USING ( FILE /data1/bz/Userdata1 512000 ) TEMPORARY TABLESPACE MANAGED BY DATABASE USING ( FILE /data1/bz/Tempspace1 768000)”于是在data1存储中又有一个名为bz和db2inst1的实例和数据文件。再将B机上DB2停止，并umount /data1，而在A机上mount /data1再启动A机上的DB2实例，连接数据库connect to bz user db2inst1 using db2inst1连接成功，说明双机切换成功完成。以后用同样的方法在A机和B机上进行切换，都能连接成功，在A机上重命名的 bz1和db2inst11都可以删除，不影响DB2切换。建库脚本：CREATE Bufferpool NCUSED4 SIZE 5120 PAGESIZE 4KCREATE Bufferpool NCUSED16 SIZE 960 PAGESIZE 16KCREATE BUFFERPOOL NCTMPUSED16 SIZE 960 PAGESIZE 16K Bufferpool可以自己定义，总数不能大于服务器内存。CREATE REGULAR TABLESPACE NNC_DATA01 PAGESIZE 16K MANAGED BY DATABASE USING ( FILE /data1/bz/nnc_data01 204800) EXTENTSIZE 8 OVERHEAD 24.1 PREFETCHSIZE 8 TRANSFERRATE 0.9 BUFFERPOOL NCUSED16CREATE REGULAR TABLESPACE NNC_INDEX01 PAGESIZE 4K MANAGED BY DATABASE USING ( FILE /data1/bz/nnc_index01 204800) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9 BUFFERPOOL NCUSED4CREATE REGULAR TABLESPACE NNC_DATA02 PAGESIZE 16K MANAGED BY DATABASE USING ( FILE /data1/bz/nnc_data02 20480) EXTENTSIZE 8 OVERHEAD 24.1 PREFETCHSIZE 8 TRANSFERRATE 0.9 BUFFERPOOL NCUSED16CREATE REGULAR TABLESPACE NNC_INDEX02 PAGESIZE 4K MANAGED BY DATABASE USING ( FILE /data1/bz/nnc_index02 40960) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9 BUFFERPOOL NCUSED4CREATE REGULAR TABLESPACE NNC_DATA03 PAGESIZE 16K MANAGED BY DATABASE USING ( FILE /data1/bz/nnc_data03 204800) EXTENTSIZE 8 OVERHEAD 24.1 PREFETCHSIZE 8 TRANSFERRATE 0.9 BUFFERPOOL NCUSED16CREATE REGULAR TABLESPACE NNC_INDEX03 PAGESIZE 4K MANAGED BY DATABASE USING ( FILE /data1/bz/nnc_index03 204800) EXTENTSIZE 32 OVERHEAD 24.1 PREFETCHSIZE 32 TRANSFERRATE 0.9 BUFFERPOOL NCUSED4CREATE USER TEMPORARY TABLESPACE USERTEMP PAGESIZE 16 K MANAGED BY SYSTEM USING ( /data1/bz/Usertemp1 ) EXTENTSIZE 32 OVERHEAD 10.67 PREFETCHSIZE 32 TRANSFERRATE 0.04 BUFFERPOOL NCTMPUSED16 CREATE SYSTEM TEMPORARY TABLESPACE TEMPSPACE2 PAGES