- 备份:
1. db2 update db cfg for <dbname> using logretain on --启用归档日志
2. db2 update db cfg for <dbname> using logarchmeth1 disk:/db2/archlog --归档目录
3. db2 force applications all --切断所有应用连接
4. db2stop force --停止DB2运行
5. db2start --启动DB2
6. db2 backup db <dbname> to /db2 --脱机备份
备份出的文件称以及路径为:
例:/db2/GOVINFO.0.db2inst1.NODE0000.CATN0000.20090112112233.001
- 恢复:
1. db2 restore db <dbname> incremental automatic from /db2/ taken at 20090112112233 --恢复指定日期
2. db2 rollforward database complete --完成回滚