Outage caused by not enough storage available in the application heap

Technote (troubleshooting)


Problem(Abstract)

Unable to execute DB2 database queries, causing a service outage. Database queries do not return, the embedded WebSphere Application Server (eWAS) service is disrupted. Tivoli Workload Scheduler (TWS) appears to be down or unresponsive.

Symptom

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

1. Determine the DB2 instance owner. You must run all of the following commands as the DB2 instance owner. This user is likely to be named db2inst1, but you can check by running the following:


<TWS_HOME>/wastools/showSecurityProperties.sh | grep j2cUserid    

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

NOTE: The default TWS database name is "TWS"

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:

db2 get database configuration | grep APPLHEAPSZ  

6. Increase the DB2 application heap size:

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

7. Restart DB2:

db2 force applications all                                  
db2stop                                                      
db2start

Product Alias/Synonym

Maestro
TWS
TWA

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Workload Scheduler
DB2

Software version:

8.3, 8.4, 8.5, 8.5.1, 8.6, 9.1, 9.2

Operating system(s):

Platform Independent

Reference #:

1597038

Modified date:

2014-06-02

Translate my page

Machine Translation

Content navigation