[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
扫描数据文件抽取数据,重建数据库,恢复数据。
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
扫描数据文件抽取数据,重建数据库,恢复数据。