DB2 打开某个库时,提示“访问配置文件时遇到系统异常,很可能是 I/O 异常。”
DB2 打开某个库时,提示“访问配置文件时遇到系统错误,很可能是 I/O 错误。”
[IBM][CLI Driver] SQL5005C 系统错误。
说明:
访问配置文件时遇到系统错误,很可能是 I/O 错误。
无法处理该命令。
用户响应:
重新提交该命令。
如果此错误仍存在,那么请检查 db2diag 日志文件以了解详细信息,并确保配置
文件可访问。如果无法解决该问题,请与 IBM 服务代表联系以获取帮助。
db2diag.log日志如下:
2013-07-23-11.45.05.765000+480 I1H1099 LEVEL: Event
PID : 2364 TID : 5768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ZHZH
APPHDL : 0-48 APPID: *LOCAL.DB2.130723034505
AUTHID : YJZH
EDUID : 5768 EDUNAME: db2agent (ZHZH) 0
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09070"
with level identifier "08010107".
Informational tokens are "DB2 v9.7.0.441", "s090521", "NT3297", Fix Pack "0".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GIS-ZHZH-SERVER Service Pack 3 5.1 x86 Family 6, model 30, stepping 5
CPU: total:8 online:8 Cores per socket:8 Threading degree per core:1
Physical Memory(MB): total:3007 free:1614 available:1614
Virtual Memory(MB): total:4894 free:2821
Swap Memory(MB): total:1887 free:1207
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2013-07-23-11.45.05.765000+480 I1103H545 LEVEL: Error
PID : 2364 TID : 5768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ZHZH
APPHDL : 0-48 APPID: *LOCAL.DB2.130723034505
AUTHID : YJZH
EDUID : 5768 EDUNAME: db2agent (ZHZH) 0
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:260
MESSAGE : SQL5005: bad file contents rc =
DATA #1 : Hexdump, 4 bytes
0x086638F8 : 0900 0F87 ....
2013-07-23-11.45.05.781000+480 I1650H442 LEVEL: Error
PID : 2364 TID : 5768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ZHZH
APPHDL : 0-48 APPID: *LOCAL.DB2.130723034505
AUTHID : YJZH
EDUID : 5768 EDUNAME: db2agent (ZHZH) 0
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:60
RETCODE : ZRC=0xFFFFEC73=-5005
2013-07-23-11.45.05.781000+480 I2094H534 LEVEL: Error
PID : 2364 TID : 5768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ZHZH