DB2 : everything about UDB universe

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.

Understanding locking in DB2 Universal Database

An illustrated example

Level: Intermediate

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.

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/

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..

This gives the step by step howto for implementing DPF in a SUSE enterprise v9

A colorful intro to db2 DPF

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

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.