Technote (troubleshooting)
Problem(Abstract)
You have a problem while processing messages through WebSphere Message Broker (WMB). What you see in the broker logs is that there is a problem with operation to the database. The error message is:
IBM CLI driver db2/nt sql0973n not enough storage available in the "APP_CTL_HEAP" heap to process the statement SQLSTATE=57011.
Resolving the problem
Processing transactions through the message flows can fail if there is not enough storage in the APPL_CTL_HEAP.
The solution to this problem is to increase Application Control heap Size from (default) 128 to something larger; for example 1024 for broker databases.
Note: This value is only a recommendation, and you should try different values to determine which are best suited for your environment.
To increase the parameter:
- Start DB2 Instance (if stopped)
- Connect to the database
- The actual 'db2' command required for increase is:
-
db2 => update db config for DBNAME using APPL_CTL_HEAP_SZ 1024
and then confirm the configuration using the following command:
db2 => get db config for DBNAME
Historical Number
54860
211
788
Product Alias/Synonym
WMB MB WebSphere Message Broker MQ Integrator WBIMB WBI-MB MQSI WMQI
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.