发布时间:2013-07-21 09:23:39
有两个DB2的数据库,由于用于存放归档日志的存储(NBU)出现故障,导致归档出现问题,日志疯涨,现将过程记录如下。第一个故障的数据库的故障现象:db2pb8> db2pd -d pb8 -logs Database Partition 0 -- Database PB8 -- Active -- Up 82 days 09:58:53 -- Date 07/19/2013 09:25:28&nbs.........【阅读全文】
发布时间:2013-07-21 09:20:08
并行备份$ db2 backup db sample PARALLELISM 4 Backup successful. The timestamp for this backup image is : 20130715092132 $ lsSAMPLE.0.db2test.NODE0000.CATN0000.20130715092132.001 db2 list history backup all for sample &nb.........【阅读全文】
发布时间:2013-07-19 09:13:13
启动一个在线备份arlqsap01:db2qsa:QSA:/db2/QSA/db2qsa> db2 list utilities ID .........【阅读全文】
发布时间:2013-07-18 10:17:20
查看当前的数据库后台任务arlqsap01:db2qsa:QSA:/db2/QSA/db2qsa> db2 list utilities ID &nbs.........【阅读全文】
发布时间:2013-07-17 10:51:52
数据库备份失败查看备份过程:Tue Jul 16 03:43:18 CEST 2013Start of check:Backup on QSA on db2qsa started at 2013-07-16-03.43.20 with 1 sessionsSQL2062N An error occurred while accessing media "VENDOR". Reason code:"518".logger -p daemon.notice -t .........【阅读全文】