DB2 数据库备份错误(目前尚无人解决),提示:SQL0980C 发生磁盘错误。不能处理后续的 SQL 语句。 SQLSTATE=58005
1 运行环境:
Windows 2000 server, db2 8.2
2 错误描述 使用备份命令如下:
db2stop force
db2start
connect to test_db user db2admin using test
backup database test_db to "e:"
开始执行正常,数据大小有6G左右,当数据库备份文件有2G左右时,执行命令报错,产生的2G的数据备份文件也删除了。报错提示如下:提示DB2 数据库备份错误,提示:SQL0980C 发生磁盘错误。不能处理后续的 SQL 语句。 SQLSTATE=58005
问题:
是否是由于硬盘坏道或是数据库文件损坏引起 ,能否修复数据库(非归档模式)??
附db2diag.log信息
查看db2日志报错信息如下
2008-08-02-22.14.02.203000+480 I1769H436 LEVEL: Error
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:1143
RETCODE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
2008-08-02-22.14.02.296000+480 I2207H442 LEVEL: Error
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:1143
DATA #1 : String, 86 bytes
Obj={pool:2;obj:170;type:0} State=x27 Page=4360 Cont=0 Offset=4360 BlkSize=12
BadPage
2008-08-02-22.14.02.312000+480 I2651H678 LEVEL: Error
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
MESSAGE : SQLB_OBJECT_DESC
DATA #1 : Hexdump, 68 bytes
0x3596D608 : 0200 AA00 0200 AA00 0000 0000 0000 594B ..............YK
0x3596D618 : 60D9 0000 0000 0000 0000 0000 0000 0000 `...............
0x3596D628 : 0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0x3596D638 : 0010 0000 2000 0000 0100 0000 0200 AA00 .... ...........
0x3596D648 : D0BB D802 ....
2008-08-02-22.14.02.500000+480 I3331H732 LEVEL: Severe
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:71
MESSAGE : DiagData
DATA #1 : Hexdump, 68 bytes
0x3596D608 : 0200 AA00 0200 AA00 0000 0000 0000 594B ..............YK
0x3596D618 : 60D9 0000 0000 0000 0000 0000 0000 0000 `...............
0x3596D628 : 0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0x3596D638 : 0010 0000 2000 0000 0100 0000 0200 AA00 .... ...........
0x3596D648 : D0BB D802 ....
2008-08-02-22.14.02.500000+480 I4065H435 LEVEL: Severe
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:72
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x3596D4BC : 0000 0000 ....
2008-08-02-22.14.02.500000+480 I4502H444 LEVEL: Severe
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:73
MESSAGE : DiagData
DATA #1 : Hexdump, 12 bytes
0x3596D500 : 0811 0000 64D5 9635 0C00 0000 ....d..5....
2008-08-02-22.14.02.500000+480 I4948H596 LEVEL: Severe
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:74
MESSAGE : DiagData
DATA #1 : Hexdump, 48 bytes
0x4FD87000 : 202C 3A48 5630 3030 3330 2020 3A48 4930 ,:HV00030 :HI0
0x4FD87010 : 3030 3330 202C 0A20 2020 2020 2020 2020 0030 ,.
0x4FD87020 : 2020 2020 2020 2020 2020 2020 203A 4856 :HV
2008-08-02-22.14.02.500000+480 I5546H435 LEVEL: Severe
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:75
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x3596D4B4 : 0811 0000 ....
2008-08-02-22.14.02.500000+480 I5983H152 LEVEL: Severe
PID:2572 TID:5228 NODE:000 Title: SQLB_PAGE
Dump File:D:\IBM\SQLLIB\DB2\25725228.000
2008-08-02-22.14.02.500000+480 I6137H477 LEVEL: Severe
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:71
MESSAGE : ** Failure on first attempt to read the page **
DATA #1 : Hexdump, 4 bytes
0x3596D4F0 : 0100 0286 ....
2008-08-02-22.14.02.500000+480 I6616H435 LEVEL: Severe
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbcres, probe:25
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x3596D454 : 0811 0000 ....
2008-08-02-22.14.02.500000+480 I7053H436 LEVEL: Error
PID : 2572 TID : 5228 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : test_db
APPHDL : 0-8 APPID: *LOCAL.DB2.080802140657
FUNCTION: DB2 UDB, buffer pool services, sqlbrdpg, probe:1143
RETCODE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.