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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.