Resolution:
Description:
============
SQL-8201 exception while searching for events related to a record.  

Environment:
==========
TIBCO Product name and version: TIBCO Collaborative Information Manager 6.1.3
Operating System(s): All Operating Systems
Database: DB2

Symptoms:
========
The following exception is thrown when searching events related to a record.
SQL-8201: Database error: com.ibm.websphere.ce.cm.StaleConnectionException: [IBM][CLI Driver][DB2/6000] SQL0973N Not enough storage is available in the "" heap to process the statement. SQLSTATE=58004.

Cause:
=====
All available memory for the heap has been used. The SQL statement cannot be processed by DB2.

Resolution:
========
Below is the information available online at IBM website at:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql0900.htm
SQL0973N

Not enough storage is available in the heap-name heap to process the statement.

Explanation:
All available memory for this heap has been used. The statement cannot be processed.

User Response:
Terminate the application on receipt of this message (SQLCODE). Modify the heap-name configuration parameter to increase the heap size.

For example, to update a database configuration parameter, issue the following command:

db2 update db cfg
for db-name
using heap-name heap-size

To view a list of the database configuration parameters, use the GET DATABASE CONFIGURATION command.

To update a database manager configuration parameter, issue the following command:

db2 update dbm cfg
for db-name
using heap-name heap-size

To view a list of the database manager configuration parameters, use the GET DATABASE MANAGER CONFIGURATION command.

For application group shared heap size, the following three database configuration parameters control its size and usage: APPGROUP_MEM_SZ, GROUPHEAP_RATIO, and APP_CTL_HEAP_SZ. The number of applications in one application group is calculated by: APPGROUP_MEM_SZ / APP_CTL_HEAP_SZ. The application group shared heap size is calculated by: APPGROUP_MEM_SZ * GROUPHEAP_RATIO / 100.

Attachments:
==========
None

References:
=========
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql0900.htm


Keywords/Tags:
=============