APPGROUP_share_heap error in db2

Thursday, August 30, 2007

SQL0973N Not enough storage is available in the
"APPGROUP_SHARE_HEAP" heap to process the statement. SQLSTATE=57011 ???


For "application group shared heap size" , you need to look at three
parameters....


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 sharedheap size is calculated by: APPGROUP_MEM_SZ
* GROUPHEAP_RATIO /100.

Posted by Agoglife at 1:57 PM  

0 comments:

Post a Comment