Search within JDBC and Relational Databases
Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
JDBC and Relational Databases
DB2 JDBC heap error
posted 19 years ago
Number of slices to send:
Optional 'thank-you' note:
COM.ibm.db2.jdbc.net.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011
This app will run and about 2 - 3 hours it will receive this error, along with this error. I am assuming that this error is happening because of the above error.
Driver] CLI0601E Invalid statement handle or statement is closed. SQLSTATE=S1000
I have increased the heap size in the DB2 control center under the Performance tab to 60000.
I have this same app running on another PC with the same data and it never fails. Is it hardware issue?
DB2 version 6.1
Win 2000/nt server
512 mega byte ram
[ October 13, 2004: Message edited by: Bear Bibeault ]
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
Boost this thread!
DB2 SQLSTATE ???
connecting to db2 using net driver
Error opening socket. SQLSTATE=08S01