By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Application heap size

P: n/a

I am writing a front-end to a Perl-based web-service running against a
DB2 v. 8.1 database, and every once in a while I get the following

DBD::DB2::db prepare failed: [IBM][CLI Driver][DB2/NT] SQL0954C Not
enough storage is available in the application heap to process the
statement. SQLSTATE=57011

The server is running Win2k and Apache2/mod_perl 1.99.

After approx. 40 calls to the database I get the error. The SQL thats
being prepared or executed is always varying, so its not a specific
SQL statement that crashes the database - it seems to be just a
certain quantity.

Ive tried increasing the heap size, but this only delays the problem.
Im new to DB2 and Id rather try to fix the problem (if possible) than
delay it.

I should mention that I had no problems when I was running Apache 1.3,
so maybe the multi-threads is whats doing it?

Any help is appreciated. Thanks in advance!
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.