db2 修改归档模式

     db2 日志模式分为循环归档，和日志归档模式，两种日志的原理介绍的很多了，我主要记录一下我实际操作的步骤

     版本： v9.7 （建立了4个分区）

     OS： AIX5.3

     DB2 默认为循环归档，根据应用要求调整为日志归档模式

    db2 connect to cqtest1

    db2 force application all

     [ibm_test1]/db2log>db2 "UPDATE DB CFG FOR CQTEST1  USING LOGARCHMETH1  'Disk:/db2log/db2logar'"
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

     [ibm_test1]/db2log>db2 connect to cqtest1   （需要备份数据库）
SQL1116N  A connection to or activation of database "CQTEST1" cannot be made
because of BACKUP PENDING.  SQLSTATE=57019

  [ibm_test1]/db2log>db2 backup database cqtest1 to /db2log/backup   （24G数据备份了5分钟）

Backup successful. The timestamp for this backup image is : 20120222172556

[ibm_test1]/db2log>db2 connect to cqtest1  (连接成功）

   Database Connection Information

 Database server        = DB2/AIX64 9.7.3
 SQL authorization ID   = DB2INST1
 Local database alias   = CQTEST1

 

但是当我连接上数据库建表是还是报错 SQL1116N  A connection to or activation of database "CQTEST1" cannot be made
because of BACKUP PENDING.  SQLSTATE=57019

 

什么原因呢？原来在分区数据库上执行 backup database 只能备份一个node。

换成

db2_all "db2 backup db cqtest1 to /db2log/backup/dpf_1,/db2log/backup/dpf_2,/db2log/backup/dpf_3,/db2log/backup/dpf_4"

[ibm_test1]/db2log/backup>db2_all "db2 backup db cqtest1 to /db2log/backup/dpf_1,/db2log/backup/dpf_2,/db2log/backup/dpf_3,/db2log/backup/dpf_4"
 

Backup successful. The timestamp for this backup image is : 20120222180237

ibm_test1: db2 backup db cqtest1 ... completed ok
 

Backup successful. The timestamp for this backup image is : 20120222180719

ibm_test1: db2 backup db cqtest1 ... completed ok
 

Backup successful. The timestamp for this backup image is : 20120222181204

ibm_test1: db2 backup db cqtest1 ... completed ok
 

Backup successful. The timestamp for this backup image is : 20120222181650

ibm_test1: db2 backup db cqtest1 ... completed ok

 

后在重启数据库问题就解决了。

 

 总结一下

db2 connect to cqtest1

db2 force application all

db2 "UPDATE DB CFG FOR CQTEST1  USING LOGARCHMETH1  'Disk:/db2log/db2logar'"

db2_all "db2 backup db cqtest1 to /db2log/backup/dpf_1,/db2log/backup/dpf_2,/db2log/backup/dpf_3,/db2log/backup/dpf_4"

db2stop

db2start

 

修改成功