DB2 SQL1042C SQLSTATE=58004的现象及恢复

来源：互联网发布：pc蛋蛋外围算账软件编辑：程序博客网时间：2024/06/08 18:28

[db2inst1@db ~]$ db2 list db directory
System Database Directory
Number of entries in the directory = 2
Database 1 entry:

Database alias = TEST
Database name = TEST
Local database directory = /db2data
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
...

[db2inst1@db ~]$ db2 connect to TEST
SQL1042C An unexpected system error occurred. SQLSTATE=58004
[db2inst1@db ~]$

db2diag.log报错如下：
2017-10-17-13.38.36.163996+480 I157540E239 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: **** DRDA ATTRIBUTES ****
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.164087+480 I157780E238 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: **** AS UCINTERFACE ****
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.164177+480 I158019E505 LEVEL: Severe
PID : 8077 TID : 47527927736640PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TEST
APPHDL : 0-53 APPID: *LOCAL.db2inst1.171017053836
AUTHID : DB2INST1
EDUID : 67 EDUNAME: db2agent (TEST) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.

2017-10-17-13.38.36.164333+480 I158525E222 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: sqeAgent
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.164519+480 I158748E228 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: sqeApplication
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.164682+480 I158977E233 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: SQLE_COORDINATOR_CB
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.164775+480 I159211E228 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: sqeApplication
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.164960+480 I159440E226 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: SQLE_TRAN_CB
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.165053+480 I159667E228 LEVEL: Severe
PID:8077 TID:47527927736640 NODE:000 Title: REPLY_NODE_MAP
Dump File:/home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/8077.67.000.dump.bin

2017-10-17-13.38.36.165169+480 I159896E616 LEVEL: Event
PID : 8077 TID : 47527927736640PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TEST
APPHDL : 0-53 APPID: *LOCAL.db2inst1.171017053836
AUTHID : DB2INST1
EDUID : 67 EDUNAME: db2agent (TEST) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10
STOP : AUTOMATIC FODC : DBMarkedBad : success
IMPACT : None
DATA #1 : String, 108 bytes
Check /home/db2inst1/sqllib/db2dump/FODC_DBMarkedBad_2017-10-17-13.38.36.090342/ for diagnostic information.

2017-10-17-13.38.36.165333+480 I160513E516 LEVEL: Severe
PID : 8077 TID : 47527927736640PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TEST
APPHDL : 0-53 APPID: *LOCAL.db2inst1.171017053836
AUTHID : DB2INST1
EDUID : 67 EDUNAME: db2agent (TEST) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:125
DATA #1 : Hexdump, 4 bytes
0x0000000200D4B9EC : EEFB FFFF

扫描数据文件抽取数据，重建数据库，恢复数据。

阅读全文

0 0