DB2数据库经常报两个错误:ZRC=0x80480003和SQLCODE:-1224
操作系统:AIX 6.1 数据库:DB2 V9.7
db2diag日志每天都会报错,以下为日志,请大神帮忙解决下。不清楚是什么原因导致的,在网上也没查到好的解决方法。
有两个错误:1)
2015-03-28-01.39.31.553042+480 I16982253A527 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-32151 APPID: *LOCAL.db2inst1.150327173945
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe:60
RETCODE : ZRC=0x80480003=-2142765053=SQLDXE_INTR "User Interrupt"
DIA8003C The interrupt has been received.
2)
2015-03-28-01.39.31.556470+480 E16982781A578 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-32151 APPID: *LOCAL.db2inst1.150327173945
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
----------------------------------------
日志内容:
2015-03-28-01.39.31.553042+480 I16982253A527 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-32151 APPID: *LOCAL.db2inst1.150327173945
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe:60
RETCODE : ZRC=0x80480003=-2142765053=SQLDXE_INTR "User Interrupt"
DIA8003C The interrupt has been received.
2015-03-28-01.39.31.556470+480 E16982781A578 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-32151 APPID: *LOCAL.db2inst1.150327173945
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-28-01.39.31.556655+480 E16983360A829 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-32151 APPID: *LOCAL.db2inst1.150327173945
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80480003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-03-28-05.39.31.748420+480 I16985221A527 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-33400 APPID: *LOCAL.db2inst1.150327213946
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe:60
RETCODE : ZRC=0x80480003=-2142765053=SQLDXE_INTR "User Interrupt"
DIA8003C The interrupt has been received.
2015-03-28-05.39.31.750545+480 E16985749A578 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-33400 APPID: *LOCAL.db2inst1.150327213946
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-28-05.39.31.750750+480 E16986328A829 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-33400 APPID: *LOCAL.db2inst1.150327213946
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80480003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-03-28-09.39.31.779308+480 E16988189A578 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-34643 APPID: *LOCAL.db2inst1.150328013945
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-28-09.39.31.779562+480 E16988768A829 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-34643 APPID: *LOCAL.db2inst1.150328013945
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80040003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-03-28-21.39.31.586847+480 I16991660A527 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-38397 APPID: *LOCAL.db2inst1.150328133943
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe:60
RETCODE : ZRC=0x80480003=-2142765053=SQLDXE_INTR "User Interrupt"
DIA8003C The interrupt has been received.
2015-03-28-21.39.31.590380+480 E16992188A578 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-38397 APPID: *LOCAL.db2inst1.150328133943
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-28-21.39.31.590594+480 E16992767A829 LEVEL: Error
PID : 22151332 TID : 7080 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-38397 APPID: *LOCAL.db2inst1.150328133943
AUTHID : DB2INST1
EDUID : 7080 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80480003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-03-29-02.44.35.257345+480 I16993597A527 LEVEL: Error
PID : 22151332 TID : 15047 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-39988 APPID: *LOCAL.db2inst1.150328184456
AUTHID : DB2INST1
EDUID : 15047 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe:60
RETCODE : ZRC=0x80480003=-2142765053=SQLDXE_INTR "User Interrupt"
DIA8003C The interrupt has been received.
2015-03-29-02.44.35.321424+480 E16994125A578 LEVEL: Error
PID : 22151332 TID : 15047 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-39988 APPID: *LOCAL.db2inst1.150328184456
AUTHID : DB2INST1
EDUID : 15047 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-29-02.44.35.321677+480 E16994704A829 LEVEL: Error
PID : 22151332 TID : 15047 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-39988 APPID: *LOCAL.db2inst1.150328184456
AUTHID : DB2INST1
EDUID : 15047 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80480003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-03-29-09.39.32.146223+480 I16997188A576 LEVEL: Error
PID : 22151332 TID : 15304 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-42130 APPID: *LOCAL.db2inst1.150329013947
AUTHID : DB2INST1
EDUID : 15304 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::fetch, probe:40
RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED"
DIA8003C The interrupt has been received.
DATA #1 : Hex integer, 4 bytes
0x0000000B
2015-03-29-09.39.32.146621+480 I16997765A551 LEVEL: Error
PID : 22151332 TID : 15304 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-42130 APPID: *LOCAL.db2inst1.150329013947
AUTHID : DB2INST1
EDUID : 15304 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::preUpdateCacheHandling, probe:40
RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED"
DIA8003C The interrupt has been received.
2015-03-29-09.39.32.150669+480 E16998317A578 LEVEL: Error
PID : 22151332 TID : 15304 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-42130 APPID: *LOCAL.db2inst1.150329013947
AUTHID : DB2INST1
EDUID : 15304 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-29-09.39.32.151082+480 E16998896A829 LEVEL: Error
PID : 22151332 TID : 15304 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-42130 APPID: *LOCAL.db2inst1.150329013947
AUTHID : DB2INST1
EDUID : 15304 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80040003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-03-29-13.39.31.989725+480 I17000757A527 LEVEL: Error
PID : 22151332 TID : 27084 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-43376 APPID: *LOCAL.db2inst1.150329053945
AUTHID : DB2INST1
EDUID : 27084 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe:60
RETCODE : ZRC=0x80480003=-2142765053=SQLDXE_INTR "User Interrupt"
DIA8003C The interrupt has been received.
2015-03-29-13.39.31.993639+480 E17001285A578 LEVEL: Error
PID : 22151332 TID : 27084 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-43376 APPID: *LOCAL.db2inst1.150329053945
AUTHID : DB2INST1
EDUID : 27084 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-29-13.39.32.002378+480 E17001864A829 LEVEL: Error
PID : 22151332 TID : 27084 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-43376 APPID: *LOCAL.db2inst1.150329053945
AUTHID : DB2INST1
EDUID : 27084 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80480003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-03-30-07.39.32.131968+480 I17005783A527 LEVEL: Error
PID : 22151332 TID : 15561 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-48978 APPID: *LOCAL.db2inst1.150329233946
AUTHID : DB2INST1
EDUID : 15561 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe:60
RETCODE : ZRC=0x80480003=-2142765053=SQLDXE_INTR "User Interrupt"
DIA8003C The interrupt has been received.
2015-03-30-07.39.32.134095+480 E17006311A578 LEVEL: Error
PID : 22151332 TID : 15561 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-48978 APPID: *LOCAL.db2inst1.150329233946
AUTHID : DB2INST1
EDUID : 15561 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10
MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data returned is (SRVDGN): "SQLERRP:SQLRRRCP
SQLCODE:-1224".
2015-03-30-07.39.32.134265+480 E17006890A829 LEVEL: Error
PID : 22151332 TID : 15561 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SPYW
APPHDL : 0-48978 APPID: *LOCAL.db2inst1.150329233946
AUTHID : DB2INST1
EDUID : 15561 EDUNAME: db2agent (SPYW) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRRRCP
sqlerrd : (1) 0x80480003 (2) 0x00000003 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: