已存在数据库设置归档模式方法:
1)断开所有数据库连接
db2 force applications all
2)离线备份数据
db2 backup db dbName
3)连接数据库&创建日志目录&设置归档模式
db2 connect to dbName
mkdir dbName
cd dbName
mkdir logs
db2 update db cfg using LOCKTIMEOUT 30 LOCKLIST 163840 MAXLOCKS 20 LOGFILSIZ 20480 LOGPRIMARY 10 LOGSECOND 10 LOGARCHMETH1 disk:/home/db2inst1/dbName/logs/
4)离线备份数据(必须)
db2 backup db dbName
5)在线备份数据
db2 backup db dbName online compress include logs
6)断开连接
db2 terminate
7)重启数据库
db2stop
db2start