467,926 Members | 1,427 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,926 developers. It's quick & easy.

Application heap size


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
  • viewed: 3249

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Kevin Grigorenko | last post: by
3 posts views Thread by Sherif ElMetainy | last post: by
reply views Thread by Raj | last post: by
2 posts views Thread by shorti | last post: by
4 posts views Thread by ggoubb | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.