DB2 Purescale 离线备份数据库报错 SQL2048N Reason Code 5, “DMS.TABLESPACE.DATA“

问题:


Db2 10.5.0.10, purescale 环境,离线备份报错 SQL2048N RC=5,对象是"DMS.TABLESPACE.DATA",而且不是一开始就报错,而是备到一半的时候才报错,备份中断。
$ db2 backup db sample to /dev/null
SQL2048N An error occuried while accessing object "DMS.TABLESPACE.DATA" 
Reason code : "5"

同一个实例下面另外一套库没有问题。

db2diag.log:

2020-12-10-22.58.33.984858+480 I36963E507            LEVEL: Severe
PID     : 14106                TID : 140180472194816 PROC : db2sysc 0
INSTANCE: db2inst              NODE : 000            DB   : SAMPLE   
HOSTNAME: HOST01
EDUID   : 1201                 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSMapAndRead, probe:3459
MESSAGE : Extent read attempt failed.
DATA #1 : unsigned integer, 8 bytes
1
DATA #2 : unsigned integer, 8 bytes
1
DATA #3 : unsigned integer, 2 bytes
2

2020-12-10-22.58.33.985672+480 I37471E189         LEVEL: Severe
PID:14106 TID:140180472194816 NODE:000 Title: BUFFER
Dump File:/home/db2inst/sqllib/db2dump/DIAG0000/14106.1201.000.dump.bin

2020-12-10-22.58.34.004979+480 E37661E685            LEVEL: Severe
PID     : 14106                TID : 140211027699456 PROC : db2sysc 0
INSTANCE: db2inst              NODE : 000            DB   : SAMPLE
APPHDL  : 0-2238               APPID: *N0.db2inst.201210144752
AUTHID  : db2inst              HOSTNAME: HOST01
EDUID   : 1228                 EDUNAME: db2bm.1130.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubResizeBufSpace, probe:632
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2048
DATA #2 : Hexdump, 28 bytes
0x00007F780CC12230 : 00F8 FFFF 444D 532E 5441 424C 4553 5041    ....DMS.TABLESPA
0x00007F780CC12240 : 4345 2E44 4154 4100 0500 0000              CE.DATA.....

2020-12-10-22.58.34.005299+480 E38347E984            LEVEL: Severe
PID     : 14106                TID : 140211027699456 PROC : db2sysc 0
INSTANCE: db2inst              NODE : 000            DB   : SAMPLE
APPHDL  : 0-2238               APPID: *N0.db2inst.201210144752
AUTHID  : db2inst              HOSTNAME: HOST01
EDUID   : 1228                 EDUNAME: db2bm.1130.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubResizeBufSpace, probe:632
MESSAGE : SQL2048N  An error occurred while accessing object "".  Reason code: 
          "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2048   sqlerrml: 21
 sqlerrmc: DMS.TABLESPACE.DATA 5
 sqlerrp : sqlubRes
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)    
           (7)      (8)      (9)      (10)        (11)     
 sqlstate:      

2020-12-10-22.59.12.733785+480 E39332E464            LEVEL: Severe
PID     : 14106                TID : 140180660938496 PROC : db2sysc 0
INSTANCE: db2inst              NODE : 000            DB   : SAMPLE
APPHDL  : 0-2238               APPID: *N0.db2inst.201210144752
AUTHID  : db2inst              HOSTNAME: HOST01
EDUID   : 1130                 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:1080
MESSAGE : Backup terminated.

 

解决方案:


数据库实际上没有问题,应该是DB2的ARPR,解决方案是设置db2set变量
DB2_BCKP_PAGE_VERIFICATION=FALSE
重启实例后离线备份正常。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值