Symptom
IDM jobs fail intermittently due to following error:
Error code -10003 SQL state:57011 - com.ibm.db2.jcc.am.SqlException:
There are not enough system resources to process the request. The request cannot be processed.
SQLCODE=-10003, SQLSTATE=57011, DRIVER=4.33.32
The database log (db2diag.log) shows JAVA heap space issue.
2024-09-15-01.18.00.723962+000 E47377953E478 LEVEL: Warning
PID : 14932 TID : 140689698453248 PROC : db2fmp
INSTANCE: db2abc NODE : 000 DB : ABC
APPID : 10.118.17.76.22040.240914102901
HOSTNAME: abc123456
FUNCTION: DB2 UDB, BSU Java support, sqlejLogExceptionToDiag, probe:1636
MESSAGE : ADM10000W A Java exception has been caught. The Java stack
traceback has been written to the db2diag log file.
2024-09-15-01.18.00.724234+000 E47378432E636 LEVEL: Warning
PID : 14932 TID : 140689698453248 PROC : db2fmp
INSTANCE: db2abc NODE : 000 DB : ABC
APPID : 10.118.17.76.22040.240914102901
HOSTNAME: abc123456
FUNCTION: DB2 UDB, BSU Java support, sqlejLogExceptionToDiag, probe:1644
DATA #1 : String, 264 bytes
java.lang.OutOfMemoryError: Java heap space
at com.ibm.db2.jcc.uw.UWConnection.ao(UWConnection.java:712)
at com.ibm.db2.jcc.uw.UWConnection.close(UWConnection.java:860)
at com.ibm.db2.jcc.uw.DB2StoredProcDriver.sqlejDestroyContext(DB2StoredProcDriver.java:171)
Read more...
Environment
- SAP on IBM Db2 for Linux, Unix and Windows
Product
Keywords
Error code -10003, SQLCODE=-10003, Java heap space, JAVA_HEAP_SZ , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , 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.