Hi,
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
error:
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! |