人保健康险数据库升级方案(在线方式)

1、人保健康险数据库迁移升级操作文档（db2）环境介绍:前期准备:三、木地数据库操作步骤:四、南中心数据库操作步骤:五、数据库冋退步骤一、环境介绍:本方案主要是为了健康险数据屮心迁移准备，根据人保健康险数据库升级方案（冷备 方式），北中心冷备后，空运备份文件到南中心，直接进行恢复。空运时间和等待时间过长。 为了尽量缩短操作窗口，本次方案采用热备份方式，通过网络传输到南中心，传输完毕后, 然后把传输过程屮新产生的fi志打包，传输到南屮心。fi志传输完毕后，进行前滚恢复。 实例用户:db2instl 实例用户宿主目录：数据库名称:lis、ilogbres、ilogrts二、前期准备（每个数据库都要进行

2、）:1、核对vg、lv数量、权限、大小是否一致（约20分钟）。 命令：# isvg# isvg -i vg_name# is -i /dev/r*2、检查用户、属组（约5分钟）。$ cat /etc/passwd$ cat /etc/group$ id user name3、检查数据库各个表空间所包含的容器名称及大小（约20分钟）$ db2 connect to lis$ db2 list tablespaces show detail$ db2 list tablespace containers for 0 show detail4、准备测试数据。创建一个表并插入数据（约5分钟）。$ db

3、2 "create table test （id int）"db20000i the sql command completed successfully.$ db2 "insert into test values （23）"db20000i the sql command completed successfully.$ db2 commitdb20000i the sql command completed successfully.5、停止一切自动执行的计划6、因为南中心已经做过多次的备份恢复测试，数据库版本安装等均正常，在做 恢复前把多余的实例

4、名删除，对license、版本号进行检查即可。# cd /opt/ibm/db2/v9."instance# ./db2ilist# ./db2idrop -f inst_name$ db2level$ db2licm -i三、北中心数据库操作步骤:1、检查当前数据库可用性（预计时间10分钟）$db2 connect to lis$ db2 "select * from table_name$ db2stop force$ db2start$ db2 list tablespaces2、备份数据库配置参数（预估时间10分钟） $mkdir ./support$ cd sup

5、port$ db2support./ -d lis s -m 3、备份重要文件系统（暂时不需要，因为本地数据都保存） $cd /backup$tar -pcvf /backup/iainst84 /iafs8iainst844、在线备份数据库lis （预估时间约120分钟/次）$cd /backup$ n ohup db2 backup db lis on line to / lis_dbbackups compress incl ude logs & nohup db2 backup db lis online compress &因为ilog相关的两个数据库很小，建议在数据

6、迁移当天进行冷备传输。$ # time db2 backup db ilogbres$# time db2 backup db i log rtss5、检查历史备份，并记录备份的时间戳$ db2 list history backup all for lis$ db2 list history backup all for ilogbres$ db2 list history backup all for i log rts6、记录当前日志序号（假设1000）,记录测试表行数（假设为1）$ db2 get db cfg for lis | grep-i first$ db2 "sel

7、ect count（*） from test"7、检查备份片的可用性（预估时间60分钟）$ db2ckbkp -h lis.0.db2instl.node0000.catn0000.20120413212256.001 image verification complete successful.8、备份文件通过网络传输到南中心。等数据全部传输完毕后，批量进行本地归档日志的传输，传输过程中要注意：a、第一次传输fl志起止序号至少从999开始b、终止日志序号要大于当前日志序号c、每次传输要进行测试表的插入操作，并记录行数信息d、最后一次传输，要停止所有业务，并进行2次以上手工日志归档。

8、$ db2 archive log for db lisdb20000i the archive log command completed successfully.四.南中心数据库操作步骤:1、安装v9.1软件（预估时间30分钟）su - root#./db2nstall2、创建实例（预估时间5分钟）cd /opt/ibm/db»v9."instance/opt/ibm/db/v9.1/instance#./db2icrt -p 50084 -u db2fencl db2instl dbi1070i program db2icrt completed successfu

9、lly.770a-lpar5-cbsdbl:root/opt/ibm/db?/v9./instance# ./db2icrt -u ilogfen ilog you have new mailyou have new maildbi1070i program db2icrt completed successfully.3、查询数据库版本（预估时间1分钟）#su 一 db2instl$ db2leveldb21085i instance ,db2isntl" uses h64h bits and db2 code release “sql09075” with level ident

10、ifier ”08050107”.informational tokens are "db2 v", "s110330", "ip23236", and fix pack n5".product is installed at ”/opt/ibm/db”v9.1”4、设置db2set变量 设置后重新登录实例用户使设置生效（预估时间2分钟）db2set db2comm=tcpipdb2set db2codepage=1386db2set db2country=86db2set db2memdisclaim=yes

11、db2set db2memmaxfree=4194304db2set db2_parallel_io=*db2set db2_evalunc0mmitted=0ndb2set db2_skipdeleted=0ndb2set db2_skipinserted=0ndb2set db2_antij0in=yesdb2set db2_inlist_t0_nun=yes5、备份文件传输完毕后，进行还原数据库（预估时间以数据库大小而不同）（预 估140分钟）切换到备份片所在当前目录$ time db2 restore db lis from /lis_dbcache taken at 20120512

12、010500 logtarget /corehome/sql2555i the database was restored and then successfully upgraded to the current db2 release where you issued the restore database command.db20000i the terminate command completed successfully.$ time db2 restore db ilogbres taken at 20120413212256 without rolling forward s

13、ql2555i the database was restored and then successfully upgraded to the current db2 release where you issued the restore database command.db20000i the terminate command completed successfully.$ time db2 restore db i log rts taken at 20120413212256 without rolling forward sql2555i the database was re

14、stored and then successfully upgraded to the current db2 release where you issued the restore database command.db20000i the terminate command completed successfully.db2 update db cfg for sample using overflowlogpath /db2fs/oldlogdb20000i the update database configuration command completed successful

15、ly /db2fs/oldlog为口志新目录sdb2 rollforward db sample to end of logs6、检查日志相关参数$ db2 get db cfg for lis |grep log7、待第一批日志传输完毕后，进行第一次前滚操作$ db2 rollforward db lis to end of logsrollforward statusin put database alias= lisnumber of no des have retur ned status=1node number=0rollforward status=db workingnext

16、log file to be read=soo468oo.loglog files processed=soo46752.log soo46798.loglast committed transaction=2012-05-14-000000 utcdb20000i the rollforward command completed successfully.8、第二次前滚操作$ db2 rollforward db lis to end of logsrollforward statusin put database alias= lisnumber of nodes ha

17、ve returned status=1node number=0rollforward status=db workingnext log file to be read=soo469oo.loglog files processed=soo46752.log - soo46898.loglast committed transaction=2012-05-16-000000 utcdb20000i the rollforward command completed successfully.9、最后一次前滚操作db2 rollforward db lis to end o

18、f logsrollforward statusin put database alias=lisnumber of nodes have returned status=1node number=0rollforward status=not pendingnext log file to be read二log files processed=soo46752.log - soo4715o.loglast committed transaction=2012-05-24-000000 utcdb20000i the rollforward command completed successfully.10、结束前滚$ db2 rollforward db lis stoprollforward statusin put database alias= lisnumber of no des have retur ned status=1node number=0rollforward status=not pendingnext log file to be read二log files processed=soo46752.log