DB2归档日志的设置

DB2归档日志的设置

1、首先查看日志类型

db2 get db cfg for 数据库 | grep LOGARCHMETH

未归档：
如果LOGARCHMETH1和LOGARCHMETH2都显示为OFF，则当前日志为循环日志

First log archive method              (LOGARCHMETH1) = OFF
Second log archive method             (LOGARCHMETH2) = OFF

归档：
如果LOGARCHMETH1或者LOGARCHMETH2其中一个显示为DISK：目录则为归档日志

First log archive method              (LOGARCHMETH1) = DISK：目录
Second log archive method             (LOGARCHMETH2) = DISK：目录
或者
First log archive method              (LOGARCHMETH1) = DISK：目录
Second log archive method             (LOGARCHMETH2) = OFF
或者
First log archive method              (LOGARCHMETH1) = OFF
Second log archive method             (LOGARCHMETH2) = DISK：目录

2、修改日志模式为归档日志

db2 update db cfg for 数据库 using LOGARCHMETH1 disk:目录
db2 update db cfg for 数据库 using LOGARCHMETH2 disk:目录

注意：
变更归档模式参数后，DB2数据库处于backup pending状态，要脱机备份一次才行．

db2 backup db 数据库名称 to 目录