云南支付结算综合业务系统DB2v8.1安装配置.docx

云南支付结算综合业务系统DB2v8.1安装配置目录一、上传介质和解压介质3二、创建db2用户组以及用户3三、安装db2和补丁73.1、安装db273.2、打补丁93.3、更改数据库用户密码103.4、修改/etc/services113.5、创建文件系统113.6、修改文件系统属性143.7、创建实例153.8、修改并行CPU 个数(根据性能测试来调整个数)163.9、DB2 配置163.10、创建数据库173.11、设置DB2 实例及数据库的参数173.12、调整数据库参数173.13、创建数据库的表空间及数据库对象193.14、数据库本地编目223.15、数据库远程编目29一、上传介质和解压介质上传db2 安装介质C58S1ML.tar和补丁介质FP13_U808888.tar到/soft目录下(A B机器都要做)#tar xvfC58S1ML.tar#cd 006_ESE_AIX5_3264_DBCS#gunzipese.dbcs.tar.gz# tar xvfese.dbcs.tar解压补丁# tarxvf FP13_U808888.tar二、创建db2用户组以及用户创建db2用户和用户组，创建后的相关信息如下：TC-Server01:/home#id db2inst1uid=1000(db2inst1) gid=1000(db2grp1) groups=1(staff)TC-Server01:/home#iddb2inst2uid=1003(db2inst2) gid=1003(db2grp2) groups=1(staff)TC-Server01:/home#iddb2fenc1uid=1001(db2fenc1) gid=1001(db2fgrp1) groups=1(staff)TC-Server01:/home#iddb2fenc2uid=1004(db2fenc2) gid=1004(db2fgrp2) groups=1(staff)TC-Server01:/home#id dasusr1uid=1002(dasusr1) gid=1002(dasadm1) groups=1(staff)#smittygroup另外的group（db2grp2、db2fgrp1、db2fgrp2、dasadm1）参考上图创建#smittyuserprofile分别如下# cd /db2inst1# cat .profilePATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.export PATHif -s $MAIL # This is at Shell startup. In normalthen echo $MAILMSG # operation, the Shell checksfi # periodically.# The following three lines have been added by UDB DB2.if -f /db2inst1/sqllib/db2profile ; then . /db2inst1/sqllib/db2profilefi# cd /db2inst2# cat .profilePATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.export PATHif -s $MAIL # This is at Shell startup. In normalthen echo $MAILMSG # operation, the Shell checksfi # periodically.# The following three lines have been added by UDB DB2.if -f /db2inst2/sqllib/db2profile ; then . /db2inst2/sqllib/db2profilefi三、安装db2和补丁3.1、安装db2#cd 006_ESE_AIX5_3264_DBCS#cdese.dbcs#./db2_install p DB2.ESE3.2、打补丁生成db2.o 文件#cd /usr/opt/db2_08_01/lib#ar-xv libdb2.a# mv shr.o /usr/lib/db2.o对DB2添加license从上传的DB2 安装介质找到db2ese.lic 文件#pwd006_ESE_AIX5_3264_DBCS/ese.dbcs/db2/license#/usr/opt/db2_08_01/adm/db2licm -a ./db2ese.lic3.3、更改数据库用户密码给用户设置口令该步骤必须做，否则在后面创建实例后连接数据库出错。passwd db2inst1passwddb2fenc1passwddasusr1passwddb2inst2passwddb2fenc2然后用户登录系统AIX Version 6Copyright IBM Corporation, 1982, 2011.login: db2fenc2db2fenc2s Password:compat: 3004-610 You are required to change your password. Please choose a new one.db2fenc2s New password:Enter the new password again:其他4个用户照此方法做3.4、修改/etc/services编辑/etc/services 文件，添加服务端口DB2c_db2inst1 40000/tcpDB2c_db2inst2 50000/tcp3.5、创建文件系统需要创建的文件系统（/ympsdb、/ymps_log、/ymps_archive、/ymps_logmirror、/yntpdb、/yntp_log、/yntp_archive、/yntp_logmirror）smittyfs创建/ympsdb文件系统实列db2inst1表空间世界大小为225G，这里为方便以后生产维护扩充到300Gsmittyfs创建/yntpdb文件系统，方法同创建/ympsdbvg文件系统， group选择dbvg创建/ymps_log、/ymps_archive、/ymps_logmirror文件系统，大小都为30G创建/yntp_log、/yntp_archive、/yntp_logmirror文件系统，大小都为30G方法参考下图3.6、修改文件系统属性drwxr-xr-x 3 db2inst1 db2grp1 256 Oct 13 10:27 ymps_archivedrwxr-xr-x 3 db2inst1 db2grp1 256 Oct 13 10:39 ymps_logdrwxr-xr-x 3 db2inst1 db2grp1 256 Oct 13 10:28 ymps_logmirrordrwxr-xr-x 3 db2inst1 db2grp1 256 Oct 13 10:24 ympsdbdrwxr-xr-x 3 db2inst2 db2grp2 256 Oct 13 10:42 yntp_archivedrwxr-xr-x 3 db2inst2 db2grp2 256 Oct 13 10:42 yntp_logdrwxr-xr-x 3 db2inst2 db2grp2 256 Oct 13 10:43 yntp_logmirrordrwxr-xr-x 3 db2inst2 db2grp2 256 Oct 13 10:36 yntpdb命令参考chown-R db2inst1:db2grp1 /ympsdb其他7个db2专用文件系统照以上方法做，此步骤非常重要！手工mount 以上7个文件系统命令参考mount /ympsdbdf -g查看当前系统挂载的文件系统3.7、创建实例#/usr/opt/db2_08_01/instance/db2icrt -s ESE -w 64 -p DB2c_db2inst1 -u db2fenc1 db2inst1#/usr/opt/db2_08_01/instance/db2icrt -s ESE -w 64 -p DB2c_db2inst2 -u db2fenc2 db2inst2实例创建完毕后通过重复执行下面的步骤来验证是否创建成功（以db2inst1为例）# su - db2inst1$ db2ilistdb2inst1db2inst2$ db2start10/13/2011 11:13:35 0 0 SQL1063N DB2START processing was successful.SQL1063N DB2START processing was successful.$ db2stop10/13/2011 11:13:42 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.$ db2level验证数据库的版本是否正确DB21085I Instance db2inst1 uses 64 bits and DB2 code release SQL08026with level identifier 03070106.Informational tokens are DB2 v20, s060801, U808888, and FixPak13.Product is installed at /usr/opt/db2_08_01.3.8、修改并行CPU 个数(根据性能测试来调整个数)#/usr/opt/db2_08_01/adm/db2licm l以上Number of licensed processors = 1 说明此DB2 只支持一个CPU ，但是系统有8个CPU。使用命令：db2licm -n DB2ESE 8改变:Number of licensed processors = 8#/usr/opt/db2_08_01/adm/db2licm -n DB2ESE 8 # 8为CPU 个数3.9、DB2 配置设置DB2 概要文件注册表参数#su - db2inst1$db2set db2comm=tcpip$db2set db2codepage=1386#su - db2inst2$db2set db2comm=tcpip$db2set db2codepage=1386使用下面命令分别验证是否更新成功。以db2inst1为例，验证方法如下：#su - db2inst1$ db2set -alli DB2COMM=tcpipi DB2CODEPAGE=1386g DB2_EEE_LICENSE_POLICY=19703291320074243.10、创建数据库#su - db2inst1$db2start$db2 create dbympsdb on /ympsdb using codesetgbk territory cn#su - db2inst2$db2start$db2 create dbyntpdb on /yntpdb using codesetgbk territory cn验证数据库是否创建成功验证方法如下：#su - db2inst1$db2 connect to ympsdb看是否能连接到数据库$db2 connect reset#su - db2inst2$db2 connect to yntpdb看是否能连接到数据库$db2 connect reset3.11、设置DB2 实例及数据库的参数调整实例参数：#su- db2inst1db2 UPDATE DBM CFG USING SHEAPTHRES 60000db2 UPDATE DBM CFG USING ASLHEAPSZ 256db2 UPDATE DBM CFG USING MON_HEAP_SZ 1024#su - db2inst2db2 UPDATE DBM CFG USING SHEAPTHRES 60000db2 UPDATE DBM CFG USING ASLHEAPSZ 256db2 UPDATE DBM CFG USING MON_HEAP_SZ 10243.12、调整数据库参数#su - db2inst1db2 update dbcfg for ympsdb using logprimary 25 LOGSECOND 10 logfilsiz 25000 logbufsz 512 newlogpath /ymps_log mirrorlogpath /ymps_logmirrordb2 update dbcfg for ympsdb using logarchmeth1 DISK:/ymps_archivedb2 UPDATE DB CFG FOR ympsdb USING SORTHEAP 4096db2 UPDATE DB CFG FOR ympsdb USING UTIL_HEAP_SZ 5000db2 UPDATE DB CFG FOR ympsdb USING APPLHEAPSZ 4096db2 UPDATE DB CFG FOR ympsdb USING LOCKLIST 40960db2 UPDATE DB CFG FOR ympsdb USING MAXLOCKS 30db2 UPDATE DB CFG FOR ympsdb USING LOCKTIMEOUT 60db2 UPDATE DB CFG FOR ympsdb USING LOGBUFSZ 512db2 UPDATE DB CFG FOR ympsdb USING NUM_IOSERVERS 7db2 UPDATE DB CFG FOR ympsdb USING NUM_IOCLEANERS 2db2 update dbcfg for ympsdb using logretain on日志由循环模式改为归档模式，需要备份数据库，才能connect$ db2connect to ympsdbSQL1116N A connection to or activation of database YMPSDB cannot be madebecause of BACKUP PENDING. SQLSTATE=57019$ db2 backup database ympsdb to /dbbackupBackup successful. The timestamp for this backup image is : 20111013140144$ db2 connect to ympsdb Database Connection Information Database server = DB2/AIX64 8.2.6 SQL authorization ID = DB2INST1 Local database alias = YMPSDB#su - db2inst2$db2 update dbcfg for yntpdb using logprimary 25 LOGSECOND 10 logfilsiz 25000 logbufsz 512 newlogpath /yntp_log mirrorlogpath /yntp_logmirrordb2 update dbcfg for yntpdb using logarchmeth1 DISK:/yntp_archivedb2 UPDATE DB CFG for yntpdb USING SORTHEAP 4096db2 UPDATE DB CFG for yntpdb USING UTIL_HEAP_SZ 5000db2 UPDATE DB CFG for yntpdb USING APPLHEAPSZ 4096db2 UPDATE DB CFG for yntpdb USING LOCKLIST 40960db2 UPDATE DB CFG for yntpdb USING MAXLOCKS 30db2 UPDATE DB CFG for yntpdb USING LOCKTIMEOUT 60db2 UPDATE DB CFG for yntpdb USING LOGBUFSZ 512db2 UPDATE DB CFG for yntpdb USING NUM_IOSERVERS 7db2 UPDATE DB CFG for yntpdb USING NUM_IOCLEANERS 2db2 update dbcfg for yntpdb using logretain on$ db2 update dbcfg for yntpdb using logretain on日志由循环模式改为归档模式，需要备份数据库，才能connectDB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.$ db2 connect to yntpdbSQL1116N A connection to or activation of database YNTPDB cannot be madebecause of BACKUP PENDING. SQLSTATE=57019$ db2 backup database yntpdb to /dbbackupBackup successful. The timestamp for this backup image is : 20111013141039$ db2 connect to yntpdb Database Connection Information Database server = DB2/AIX64 8.2.6 SQL authorization ID = DB2INST2 Local database alias = YNTPDB3.13、创建数据库的表空间及数据库对象# su - db2inst1$ db2 connect to ympsdb Database Connection Information Database server = DB2/AIX64 8.2.6 SQL authorization ID = DB2INST1 Local database alias = YMPSDB$ db2 set current schema ympsdbDB20000I The SQL command completed successfully.$db2 CREATE BUFFERPOOL BUF8K SIZE 1000000 PAGESIZE 8192 NOT EXTENDED STORAGE$db2创建表空间脚本如下：建议用UltraEdit软件修改，注意换行进入db2 SQL命令模式CREATE REGULAR TABLESPACE TBS_ACT1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_ACT1_01.dbf 5000M,file /ympsdb/TBS_ACT1_02.dbf 5000M,file /ympsdb/TBS_ACT1_03.dbf 5000M,file /ympsdb/TBS_ACT1_04.dbf 5000M,file /ympsdb/TBS_ACT1_05.dbf 5000M,file /ympsdb/TBS_ACT1_06.dbf 5000M,file /ympsdb/TBS_ACT1_07.dbf 5000M,file /ympsdb/TBS_ACT1_08.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_ACT_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_ACT_INDX_01.dbf 5000M,file /ympsdb/TBS_ACT_INDX_02.dbf 5000M,file /ympsdb/TBS_ACT_INDX_03.dbf 5000M,file /ympsdb/TBS_ACT_INDX_04.dbf 5000M,file /ympsdb/TBS_ACT_INDX_05.dbf 5000M,file /ympsdb/TBS_ACT_INDX_06.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_OTHERS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_OTHERS_01.dbf 5000M,file /ympsdb/TBS_OTHERS_02.dbf 5000M,file /ympsdb/TBS_OTHERS_03.dbf 5000M,file /ympsdb/TBS_OTHERS_04.dbf 5000M,file /ympsdb/TBS_OTHERS_05.dbf 5000M,file /ympsdb/TBS_OTHERS_06.dbf 5000M,file /ympsdb/TBS_OTHERS_07.dbf 5000M,file /ympsdb/TBS_OTHERS_08.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_OTHERS_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_OTHERS_INDX_01.dbf 5000M,file /ympsdb/TBS_OTHERS_INDX_02.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_PAY_01.dbf 5000M,file /ympsdb/TBS_PAY_02.dbf 5000M,file /ympsdb/TBS_PAY_03.dbf 5000M,file /ympsdb/TBS_PAY_04.dbf 5000M,file /ympsdb/TBS_PAY_05.dbf 5000M,file /ympsdb/TBS_PAY_06.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY_HIS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_PAY_HIS_01.dbf 5000M,file /ympsdb/TBS_PAY_HIS_02.dbf 5000M,file /ympsdb/TBS_PAY_HIS_03.dbf 5000M,file /ympsdb/TBS_PAY_HIS_04.dbf 5000M,file /ympsdb/TBS_PAY_HIS_05.dbf 5000M,file /ympsdb/TBS_PAY_HIS_06.dbf 5000M,file /ympsdb/TBS_PAY_HIS_07.dbf 5000M,file /ympsdb/TBS_PAY_HIS_08.dbf 5000M,file /ympsdb/TBS_PAY_HIS_09.dbf 5000M,file /ympsdb/TBS_PAY_HIS_10.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY_HIS_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_PAY_HIS_INDX_01.dbf 5000M,file /ympsdb/TBS_PAY_HIS_INDX_02.dbf 5000M,file /ympsdb/TBS_PAY_HIS_INDX_03.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /ympsdb/TBS_PAY_INDX_01.dbf 5000M,file /ympsdb/TBS_PAY_INDX_02.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON$db2 connect reset$exit检查日志中是否出错：如果有错误，需要查找原因。yntpdb方法同上$CREATE BUFFERPOOL BUF8K SIZE 1000000 PAGESIZE 8192 NOT EXTENDED STORAGE$db2创建表空间脚本如下：建议用UltraEdit软件修改，注意换行CREATE REGULAR TABLESPACE TBS_ACT IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_ACT_01.dbf 5000M,file /yntpdb/TBS_ACT_02.dbf 5000M,file /yntpdb/TBS_ACT_03.dbf 5000M,file /yntpdb/TBS_ACT_04.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_ACT_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_ACT_INDX_01.dbf 5000M,file /yntpdb/TBS_ACT_INDX_02.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_LOG IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_LOG_01.dbf 5000M,file /yntpdb/TBS_LOG_02.dbf 5000M,file /yntpdb/TBS_LOG_03.dbf 5000M,file /yntpdb/TBS_LOG_04.dbf 5000M,file /yntpdb/TBS_LOG_05.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_LOG_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_LOG_INDX_01.dbf 5000M,file /yntpdb/TBS_LOG_INDX_02.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_OTHERS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_OTHERS_01.dbf 5000M,file /yntpdb/TBS_OTHERS_02.dbf 5000M,file /yntpdb/TBS_OTHERS_03.dbf 5000M,file /yntpdb/TBS_OTHERS_04.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_OTHERS_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_OTHERS_INDX_01.dbf 5000M,file /yntpdb/TBS_OTHERS_INDX_02.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_PAY_01.dbf 5000M,file /yntpdb/TBS_PAY_02.dbf 5000M,file /yntpdb/TBS_PAY_03.dbf 5000M,file /yntpdb/TBS_PAY_04.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY_HIS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_PAY_HIS_01.dbf 5000M,file /yntpdb/TBS_PAY_HIS_02.dbf 5000M,file /yntpdb/TBS_PAY_HIS_03.dbf 5000M,file /yntpdb/TBS_PAY_HIS_04.dbf 5000M,file /yntpdb/TBS_PAY_HIS_05.dbf 5000M,file /yntpdb/TBS_PAY_HIS_06.dbf 5000M,file /yntpdb/TBS_PAY_HIS_07.dbf 5000M,file /yntpdb/TBS_PAY_HIS_08.dbf 5000M,file /yntpdb/TBS_PAY_HIS_09.dbf 5000M,file /yntpdb/TBS_PAY_HIS_10.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY_HIS_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_PAY_HIS_INDX_01.dbf 5000M,file /yntpdb/TBS_PAY_HIS_INDX_02.dbf 5000M,file /yntpdb/TBS_PAY_HIS_INDX_03.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ONCREATE REGULAR TABLESPACE TBS_PAY_INDX IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING (file /yntpdb/TBS_PAY_INDX_01.dbf 5000M,file /yntpdb/TBS_PAY_INDX_02.dbf 5000M) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL BUF8K OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON3.14、数据库本地编目在A机停掉数据库#su- db2inst1$db2 force application all$db2stop#su - db2inst2$db2 force application all$db2stop在A机上umount文件系统#umount/ympsdb#umount/ymps_log#umount/ymps_archive#umount/ymps_logmirror#umount/yntpdb#umount/yntp_l