Prev: DB2 and REXX
Next: SQL0954C Not enough storage is available in the application heapto process the statement. SQLSTATE=57011
From: Justin on 10 Apr 2007 15:50

Recieved the message: SQL0954C Not enough storage is available in the
application heap to process
the statement. SQLSTATE=57011

After viewing other posts, they recommended changing the applheapsz
(which was completed). We have restarted DB2. The query is not too
complex. The interesting point is that we ran the query yesterday
with no issues. The server we are testing is a new box in which
multiple "break DB2" queries were executed. This includes a cartesion
product that ran for a couple hours.

So, did I break the DB2 internal self memory manager. Queries that
ran yesterday - fail today. Also tried db2 reset database manager
configuration.

Thanks,

jb

 | 
Pages: 1
Prev: DB2 and REXX
Next: SQL0954C Not enough storage is available in the application heapto process the statement. SQLSTATE=57011