DB2版本如下:
$ db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09076"
with level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120629", "IP23414", and Fix Pack
"6".
Product is installed at "/opt/IBM/db2/V9.7".
全部日志详见附件:2017-04-14日志.txt
主要报错信息如下:
第一部分:
2017-04-14-09.58.06.211433+480 I4055991699A597 LEVEL: Error
PID : 39977154 TID : 45485 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : PBCHR57
APPHDL : 0-22077 APPID: 11.129.179.73.38272.170221072944
AUTHID : PBCHR
EDUID : 45485 EDUNAME: db2agent (PBCHR57) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::fetch, probe:40
RETCODE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead lock detected"
DIA8002C A deadlock has occurred, rolling back transaction.
DATA #1 : Hex integer, 4 bytes
0x0000000B
2017-04-14-10.00.17.213647+480 I4055992297A597 LEVEL: Error
PID : 39977154 TID : 26821 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : PBCHR57
APPHDL : 0-14213 APPID: 11.129.179.73.60822.170208081445
AUTHID : PBCHR
EDUID : 26821 EDUNAME: db2agent (PBCHR57) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::fetch, probe:40
RETCODE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead lock detected"
DIA8002C A deadlock has occurred, rolling back transaction.
DATA #1 : Hex integer, 4 bytes
0x0000000B
第二部分:
2017-04-14-10.39.59.261894+480 E4057615327A776 LEVEL: Error
PID : 39977154 TID : 121708 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : PBCIUFO
APPHDL : 0-61327 APPID: 11.129.179.74.35962.170414023959
AUTHID : PBCHR
EDUID : 121708 EDUNAME: db2agent (PBCIUFO) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:10
MESSAGE : ADM14005E The following error occurred: "AppErr". First Occurrence
Data Capture (FODC) has been invoked in the following mode:
"Automatic". Diagnostic information has been recorded in the
directory named
"/home/db2inst1/sqllib/db2dump/FODC_AppErr_2017-04-14-10.39.59.261088
_39977154_121708_000/".
这部分会生成大量的 FODC_AppErr_文件
具体内容详见附件。
第一部分是死锁产生回滚
第二部分这是什么情况呀?
求救。
附件:
39977154.121708.000.stack.txt (305.22 KB)
46690004.000.locklist.txt (26.33 KB)
2017-04-14日志.txt (2.18 MB)