db2 修改归档模式

最新推荐文章于 2021-09-13 08:50:23 发布

滴水穿石

最新推荐文章于 2021-09-13 08:50:23 发布

阅读量2.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： db2 文章标签： db2 database ibm image authorization application

本文链接：https://blog.youkuaiyun.com/u9999/article/details/7284228

db2 专栏收录该内容

5 篇文章

订阅专栏

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