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".
"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
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.