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.

Great article about DB2 locking

Wednesday, August 08, 2007

Understanding locking in DB2 Universal Database

An illustrated example

Level: Intermediate

How Can Statistics Be Updatee Using SQL

Monday, August 06, 2007


Post new reply
I'm afraid. you are mistaken ... You can do runstats from local or remote as long
as you are able to connect to the database ... But the reason you are unable to
RUNSTATS from java is that - RUNSTATS is a command and not SQL ...

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

If you are atleast on FP9 of Version 8, then you can use ADMIN_CMD stored procedure
to do RUNSTATS.

DB2 Viper 2 compatibility features

Wednesday, August 01, 2007

Make your applications port easier.

Below is a post by Serge Releiu talking about DB2's sql avatar, and how we can
use them with caution to tackle porting worries..


http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707rielau/