急急急急急急急急急急急
DB2 在做Import 导入数据的时候 由于数据量过大 而且没有分段提交 导致数据库死掉
重启无效后 不小心将循环日志给删除了
在重启的时候 说日志文件不存在 并且数据库也被标记为不可用
下面是一些错误代码
请各位帮帮忙 在线等
[db2inst1@hp380-33 ~]$ db2 connect to dmcxdb
SQL1042C An unexpected system error occurred. SQLSTATE=58004
2012-03-02-16.28.47.398550+480 I27154212379E308 LEVEL: Error
PID : 10876 TID : 183030241216PROC : db2loggr (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgole, probe:1440
MESSAGE : Error -2045771763 opening database log extent 0:
2012-03-02-16.28.47.398628+480 I27154212688E384 LEVEL: Error
PID : 10876 TID : 183030241216PROC : db2loggr (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgicl, probe:2130
RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
2012-03-02-16.28.47.398777+480 I27154213073E390 LEVEL: Error
PID : 10876 TID : 183030241216PROC : db2loggr (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInit, probe:1150
2012-03-02-16.28.47.421452+480 I27154214414E469 LEVEL: Severe
PID : 9950 TID : 183030241216PROC : db2agent (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-158 APPID: PB1A10AD.L082.120302082847
AUTHID : DMCX
FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:3600
RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
2012-03-02-16.28.47.421904+480 E27154215729E372 LEVEL: Severe
PID : 9950 TID : 183030241216PROC : db2agent (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-158 APPID: PB1A10AD.L082.120302082847
AUTHID : DMCX
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "DMCXDB " marked bad.
2012-03-02-16.49.24.652034+480 I27154660416E374 LEVEL: Error
PID : 12106 TID : 183030241216PROC : db2loggr (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:320
RETCODE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
2012-03-02-16.49.24.653102+480 I27154660791E620 LEVEL: Error
PID : 12106 TID : 183030241216PROC : db2loggr (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:320
2012-03-02-09.34.34.245822+480 I137281108E393 LEVEL: Error
PID : 2154 TID : 183030241216PROC : db2loggw (DMCXDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgOpenNextExt, probe:10340
RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File cannot be used"
DIA8414C Logging can not continue due to an error.
[解决办法]
没有日志,你的数据库已经没法在使用了
还有建议你了解一下db2dart
[解决办法]
没有日志,数据库应该恢复不了了。