默认情况为循环日志,也就是无法进行日志归档或在线备份,若需要进行在线备份,需修改为归档日志模式。对于v9.5以后的版本,貌似只需要修改First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/db2data/ 这一个参数即可实现在线归档。db2 update db cfg for db2name using logarchmeth1 'disk:/home/db2inst1/db2data'LOGARCHMETH1这个即设置归档的方式,可以指定DISK、TSM等参数。修改该参数后需要重启数据库才可生效。
[db2inst1@localhost backup]$ db2stop force11/25/2013 22:17:02 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.[db2inst1@localhost backup]$ db2start11/25/2013 22:17:07 0 0 SQL1063N DB2START processing was successful.SQL1063N DB2START processing was successful.[db2inst1@localhost backup]$ db2 connect to sampleSQL1116N A connection to or activation of database "SAMPLE" cannot be madebecause of BACKUP PENDING. SQLSTATE=57019发现重启后还是不能连接,这时数据库状态为BACKUP PENDING,需要做一个备份,记住是离线备份。db2 backup db sample to离线备份完成后&#x