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  

Great article about DB2 locking

Wednesday, August 08, 2007

Understanding locking in DB2 Universal Database

An illustrated example

Level: Intermediate

Posted by Agoglife at 4:42 PM 0 comments  

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.

Posted by Agoglife at 10:02 AM 0 comments  

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/

Posted by Agoglife at 11:20 AM 0 comments  

Cursor in UDFs ??

Wednesday, July 25, 2007

SQL PL can be categorized into two technologies.
One is "inline" SQL PL, the other, what I like to call "packaged" or
"compiled" SQL PL.
Procedures are compiled once into static SQL when they are created.

SQL Functions, Methods and Triggers as well as a standalone BEGIN ATOMIC
.... END statement (a dynamic compound) are not compiled into separate
objects. A trigger or SQL function get macro expanded into the
surrounding statement and compield within it's context.
This is very powerful technology, but also very tricky.
Consequently inline SQL PL has only a subset of the statements at its
disposal.
These are:
FOR loop (which is very close to a CURSOR)
WHILE
SET
ITERATE
CONTINUE
SIGNAL
GET DIAGNOSTICs
DECLARE variable
DECLARE condition
IF THEN ELSE

I know of only two things that inline SQL PL can do today that packaged
SQL PL cannot:
Multi column set (SET (a, b, c) = (....))
and SELECT and VALUES without INTO clauses

The former is on the todo list, the later is a historical feature.

Thanks to Serge Rielau, IBM Toronto labs..

Posted by Agoglife at 9:13 AM 0 comments  

Leverage data partitioning for scalability and high performance on Linux

Friday, June 29, 2007

Posted by Agoglife at 10:32 AM 0 comments  

Secrets surrounding db2 locking behaviour

Thursday, May 31, 2007

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0501melnyk/

Posted by Agoglife at 9:26 AM 0 comments  

Packages : concepts, examples and common problems

Friday, April 20, 2007

I am changing this blog into a full db2 blog that I am going to note down my everyday experiences and links that I wont want to miss.. The 1st of them is about packages, which is not an easily understandable concept in db2 atleast in UDB universe.

Packages : concepts,examples and common problems

Below is the blog of Dwaine Snow, the author of
Advanced db2 dba certification 704 ..book

Dwaine Snow's blog

And atlast this is Susan Visser's blog on IBM pubs in everything DB2 UDB.

Posted by Agoglife at 3:53 PM 0 comments