2507114 - SQL1224N - AGENT TERMINATING" was detected | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2507114 - SQL1224N - AGENT TERMINATING" was detected

Symptom

      The db2diag.log may show the following Errors/Warnings when an application connects to the database

  • When a connection is made to the Database
    SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress,
    or has terminated your particular request due to an error or a force interrupt. SQLSTATE=55032
  • When there is a Memory resource issue and db2stmm failed to require more memory from OS.
    2010-05-19-04.38.44.717026+480 E18683472A640 LEVEL: Warning
    PID : 000000 TID : 00000 PROC : db2sysc 0
    INSTANCE: jdoe NODE : 000 DB : jdoeDB
    APPHDL : 0-32280 APPID: *LOCAL.DB2.000000000000
    AUTHID : MP_SVCDB
    EDUID : 11566 EDUNAME: db2stmm (MPHISDB) 0
    FUNCTION: DB2 UDB, Self tuning memory manager,
    stmmCheckIfFreeMemoryIsEnoughForSizeIncr, probe:555
    MESSAGE : ZRC=0xFFFFEC49=-5047
    DATA #1 : String, 143 bytes
    There is not enough free memory for size increase. Free memory in pages:
    Physical memory = 0, Instance memory = 388599, Database memory = 49152
  • When there is a lock timeout
    2017-07-05-17.47.20.943196+120 E116320558A611 LEVEL: Error
    PID : 0000000 TID : 00000 PROC : db2sysc 0
    INSTANCE: db2xxx NODE : 000 DB : XXX
    APPHDL : 0-22452 APPID: *LOCAL.db2xxx.000000000
    AUTHID : DB2XXX HOSTNAME: jdoe  
    EDUID : 63741 EDUNAME: db2agent (XXX) 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:SQLE05A 
    SQLCODE:-1224".
    Lock Time out Reson code 68
    2017-07-05-17.47.20.943196+120 E116320558A611 LEVEL: Error
    PID : 0000000 TID : 00000 PROC : db2sysc 0
    INSTANCE: db2xxx NODE : 000 DB : XXX
    APPHDL : 0-22452 APPID: *LOCAL.db2xxx.000000000
    AUTHID : DB2XXX HOSTNAME: smcci1p2
    EDUID : 63741 EDUNAME: db2agent (XXX) 0
    FUNCTION: DB2 UDB, database monitor, sqmUpdateConfigFileSignature, probe:5711
    RETCODE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT
    "LockTimeOut - tran rollback Reason code 68"
    DATA #1 : String, 129 bytes
    Warning: Failure to store config update time in catalogs. Extra change history DBCFGVALUES/DBMCFGVALUES events may be generated.

Read more...

Environment

DB2 LUW (Windows, Linux, Unix)

Product

SAP Solution Manager 7.2

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.