Symptom
- The short dump of an ABAP program shows a failure.
- The dev_w* trace shows sql error -1224.
- When the date and time is matched in the db2diag.log, an entry similar to the following can be found:
2015-02-04-17.37.32.259884-360 E51866381A578 LEVEL: Error
PID : 00000000 TID : 63997 PROC : db2sysc 0
INSTANCE: db2<SID> NODE : 000 DB : <SID>
APPHDL : 0-35609 APPID:
AUTHID : SAP<SID>
EDUID : 63997 EDUNAME: db2agent (<SID>) 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:sqlpgRes
SQLCODE:-1224".2015-02-04-17.37.32.260192-360 E51866960A829 LEVEL: Error
PID : 00000000 TID : 63997 PROC : db2sysc 0
INSTANCE: db2<SID> NODE : 000 DB : <SID>
APPHDL : 0-35609 APPID:
AUTHID : SAP<SID>
EDUID : 63997 EDUNAME: db2agent (<SID>) 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 : sqlpgRes
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x007F551E
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: - Additionally the issue can manifest in the db2diag.log for 10.5 fixpack 8 showing an"Interrupt from application".
2016-07-11-03.37.02.506283+120 I1924A614 LEVEL: Error
<<<----
PID : xxx TID : 17590466310624 PROC :
db2sysc 0
INSTANCE: xxxxxx NODE : 000 DB :
SAMPLE
APPHDL : 0-28242 APPID:
*LOCAL.xxxxxxxxxx
AUTHID : db2xxxxx HOSTNAME:xxxxxxx.net
EDUID : 9539 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, catalog services,
sqlrlCatalogScan::postUpdateCacheHandling, probe:10
RETCODE : ZRC=0x80100003=-2146435069=SQLP_LINT "Interrupt from
application"
DIA8003C The interrupt has been received. - Further checking the db2optstats you can see a more detailed overview of the table access
2016-07-11-03.37.02.524436+120 I1126219A885 LEVEL: Warning
PID : xxx TID : 17590497833440 PROC :
db2acd 0
INSTANCE: db2xxxx NODE : 000
HOSTNAME: xxxxxxx.net
FUNCTION: DB2 UDB, Automatic Table Maintenance,
JitsDaemon::runstats, probe:70
MESSAGE : ZRC=0xFFFFFB38=-1224
SQL1224N The database manager is not able to accept new
requests,
has terminated all requests in progress, or has terminated the
specified request because of an error or a forced interrupt.
DATA #1 : String, 171 bytes
AutoStats: Non zero code from Runstats commit, typically
indicating that Runstats was forced because another command (for
example DROP TABLE) needed exclusive table access
DATA #2 : String, 10 bytes
RTS Daemon
DATA #3 : String, 70 bytes
ROLLBACK Failed - issuing disconnect/connect to release the
locks held
Read more...
Environment
Db2 IBM
Keywords
- DB6 DIA5000C "AGENT TERMINATING" "SQLCODE:-1224" -1224
- The diagnostic data returned is (SRVDGN): "SQLERRP:sqlpgRes SQLCODE:-1224".
- DIA8003C The interrupt has been received, db2optstats, ZRC=0x80100003=-2146435069=SQLP_LINT "Interrupt from
application"
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.