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.
SAP Knowledge Base Article - Preview