DB2归档日志设置
su - db2inst1
db2 force applications all
db2 connect to exoa
linux版本
mkdir /home/db2inst1/db2_log/
windows版本
新建目录并授权db2用户完全控制
linux版本
db2 update db cfg using LOCKTIMEOUT 30 LOCKLIST 163840 MAXLOCKS 20 LOGFILSIZ 400000 LOGPRIMARY 13 LOGSECOND 4 LOGARCHMETH1 "disk:/home/db2inst1/db2_log/"
windows版本
db2 update db cfg for exoa using LOCKTIMEOUT 30 LOCKLIST 163840 MAXLOCKS 20 LOGFILSIZ 400000 LOGPRIMARY 13 LOGSECOND 4 LOGARCHMETH1 "disk:C:\DB2\DB2LOG"
db2 force applications all
db2 deactivate db exoa
db2 activate db exoa
db2 terminate
linux版本(离线)
db2 backup db exoa to /home/db2inst1/db2_log/
windows版本(离线)
db2 backup db exoa to C:\DB2\DB2LOG
在线备份(与上面的离线备份二选一)
db2 backup db exoa online compress include logs
归档检测(强制归档命令,用来检测归档日志是否生效)
首先终止数据库
db2 terminate
然后
db2 archive log for db exoa
db2活动日志占用的最大空间计算公式
(logprimary + logsecond) * logfilsiz * 4096 KB
归档日志设置是否成功的检测方式
创建表:
db2 "create table student(id int not null,name varchar(20),sex smallint,phone varchar(12),address varchar(30))";
向表中插入10万条数据
db2 "insert into student with t1(col1) as (values(100001) union all select t1.col1+1 from t1 where t1.col1<200000) select t1.col1,'chaeles',0,'153387766677','JINAN' from t1";