not enough storage is available in the application heap to process the statement.. sqlcode=-954 sqlstate=57011,




SystemOut.log shows: 

AWSJDB801E An internal error has been found while accessing the database. The internal error message is:
"Not enough storage is available in the application heap to process the statement.. SQLCODE=-954, SQLSTATE=57011, DRIVER=3.62.56".

Cause


DB2's application heap is exhausted by larger SQL queries performed by TWS or TWS operators.

Resolving the problem


2. Login as the DB2 instance owner.

3. Determine the name of the database used by the Tivoli Workload Scheduler (TWS) master from the list produced by the following command:

db2 list database directory

4. Run the following command to connect to the database:

db2 connect to <Database name from step 2>

5. Run the following command to determine the current "Default application heap" value:

get database configuration

6. Increase the DB2 application heap size:

UPDATE DB CFG FOR <DB Name> USING APPLHEAPSZ <Original value * 2>

7. Restart DB2:

db2 force applications all                                  
db2stop                                                      
db2start

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.