Try increasing applheapsz -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sinha, Abhijit Sent: 12 August 2003 22:10 To: 'Sunil Inchal'; [EMAIL PROTECTED] org; [EMAIL PROTECTED] Subject: RE: [DB2EUG] Out of Memory Error
Sunil, Looks like too many recursive calls in the app. That is blowing up the memory allocated to stack. Check whether the application is making too many recursive stored proc calls, or too many nested calls without return. I am guessing it is stored procs from your initial email when you were getting outOfMemoryError on the DB2StoredProcDriver. I do not know if it is possible to increase the memory allocated for stack. Guess that is platform-architecture dependent. Abhijit -----Original Message----- From: Sunil Inchal [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 4:45 PM To: [EMAIL PROTECTED] org; Sinha, Abhijit; [EMAIL PROTECTED] Subject: RE: [DB2EUG] Out of Memory Error Hi, I did increase the JAVA_HEAP_SZ parameter. But now I'm getting the following error. Please help 2003-08-12-14.42.56.940872 Instance:db2inst1 Node:000 PID:28134(db2fmp (Java) 0) TID:1800 Appid:none BSU Java support sqlejLogException Probe:10 java.lang.StackOverflowError at COM.ibm.db2.jdbc.app.DB2Connection.deferSPConnectionClose(Native Meth od) at COM.ibm.db2.jdbc.app.DB2Connection.close(DB2Connection.java(Compiled Code)) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep tionGenerator.java(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2Connection.close2(DB2Connection.java(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2Connection.close(DB2Connection.java(Compiled Code)) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep tionGenerator.java(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2Connection.close2(DB2Connection.java(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2Connection.close(DB2Connection.java(Compiled Code)) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep tionGenerator.java(Compiled Code)) -----Original Message----- From: Sinha, Abhijit [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:12 AM To: 'Sunil Inchal' Subject: RE: [DB2EUG] Out of Memory Error Sunil, This is a DBM CFG parameter, to be set at the server level. Abhijit -----Original Message----- From: Sunil Inchal [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 12:06 PM To: Sinha, Abhijit Subject: RE: [DB2EUG] Out of Memory Error Hi Abhjijit, Is it a DB CFG or DBM CFG? or it has to be set at application level i.e. client machine... he is using Websphere. Thanks Sunil -----Original Message----- From: Sinha, Abhijit [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:57 AM To: 'Sunil Inchal' Subject: RE: [DB2EUG] Out of Memory Error JAVA_HEAP_SZ -----Original Message----- From: Sunil Inchal [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 11:51 AM To: [EMAIL PROTECTED] Subject: [DB2EUG] Out of Memory Error Hi all, We are using DB2 V8.1. When executing a stored procedure db2diag.log shows the following error message and process hangs. ADM10000W A Java exception has been caught. The Java stack traceback has been written to the db2diag.log. 2003-08-12-09.20.39.636393 Instance:db2inst1 Node:000 PID:50750(db2fmp (Java) 0) TID:1800 Appid:none BSU Java support sqlejLogException Probe:10 java.lang.OutOfMemoryError at sqlj.runtime.ref.ConnectionContextImpl.<init>(ConnectionContextImpl.j ava(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2StoredProcDriver.sqlejSetupContext(DB2StoredP rocDriver.java(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2StoredProcDriver.sqlejSetupContext(DB2StoredP rocDriver.java(Compiled Code)) What could be causing this error and what memory parameters to modify, if any. Thanks in advance Sunil - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
