OS:windows xp DB2:8.2
数据库:离线库
描述:进行数据库恢复时,发生以下错误提示:
D:backup>db2 restore db ricdb from d:backup taken at 20080417113217
SQL2539W 警告!正在复原至与备份映像数据库相同的现有数据库。数据库文件将被删除。
想要继续吗?(y/n) y
SQL0980C 发生磁盘错误。不能处理后续的 SQL 语句。 SQLSTATE=58005
D:backup>db2 connect to ricdb
SQL1119N 由于先前的复原不完整,所以不能连接或激活数据库 "RICDB"。
SQLSTATE=57019
问题:
1.这个情况是如何造成的?
2.关键是这个问题应该如何解决?
哪位赐教下
===============================================
2008-09-26-22.03.16.890000+480 I1H929 LEVEL: Event
PID : 2312 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120
START : New db2diag.log file
DATA #1 : Build Level, 124 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.11.973", "s060120", "WR21365", FixPak "11".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT DOWELL-0192669 Service Pack 2 5.1 x86 Family 6, model 13, stepping 8
CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:2039 free:1406 available:1406
Virtual Memory(MB): total:2654 free:3412
Swap Memory(MB): total:615 free:2006
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2008-09-26-22.03.16.890000+480 I933H324 LEVEL: Warning
PID : 2312 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeaderFromDevice, probe:139
MESSAGE : Transfer buffer size was changed from 0 to 8916992
2008-09-26-22.03.16.921000+480 I1259H414 LEVEL: Warning
PID : 2312 TID : 2316 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : RICDB
APPHDL : 0-41 APPID: *LOCAL.DB2.080926140316
FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg, probe:1
DATA #1 : String, 50 bytes
Starting a full database restore.
Agent PID: 2316
2008-09-26-22.03.16.921000+480 I1675H438 LEVEL: Severe
PID : 2312 TID : 2316 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : RICDB
APPHDL : 0-41 APPID: *LOCAL.DB2.080926140316
FUNCTION: DB2 UDB, database utilities, sqluCompareDB, probe:45
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x02470EE8 : EB09 0000 ....
2008-09-26-22.03.41.015000+480 I2115H361 LEVEL: Error
PID : 2312 TID : 5928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbDeleteDir, probe:810
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
2008-09-26-22.03.41.015000+480 I2478H347 LEVEL: Error
PID : 2312 TID : 5928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbDeleteDir, probe:810
MESSAGE : Error deleting directory G:新建文件夹. Manual cleanup may be
required.
2008-09-26-22.03.41.015000+480 I2827H368 LEVEL: Error
PID : 2312 TID : 5928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:855
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
2008-09-26-22.03.41.015000+480 I3197H351 LEVEL: Error
PID : 2312 TID : 5928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:855
MESSAGE : Error releasing container 0 (G:新建文件夹) for tbsp 9. Rc =
860F000A
2008-09-26-22.03.41.015000+480 I3550H371 LEVEL: Error
PID : 2312 TID : 5928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSFreePoolContainers, probe:0
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
2008-09-26-22.03.41.015000+480 I3923H370 LEVEL: Error
PID : 2312 TID : 5928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbEmptyOrRemovePoolI, probe:905
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
收起