Hi,

We are getting following errors while execution of some Java report which internally call a Stored Procedure:

SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011
SQL0973N Not enough storage is available in the "PCKCACHESZ" heap to process the statement. SQLSTATE=57011

This error is coming when the application is being used under heavy load using WAS 5.1.
But the same have been working previously with DB UDB 7.2, under similar load condition, using WAS 4.

We tried increasing Application Heap Size as well as PCKCACHESZ also , around double than as that of DB2 7.2 configuration, but error remains.

It seems that memory handling with DB2 UDB8.1 is very much different from that of DB2 UDB7.2. May be we need to tune the database further.

Please revert back in case anybody has encountered similar situation and has some ideas/solutions regarding the same.

Thanks & Regards,
Harpreet

You don't mention what the parm was changed too, but after we upgraded to V8, we needed to up ours to 24990, and on a second note, there is a bug that was introduced in Fixpak 3, and supposely fixed in fixpak 7, that once it allocated the package cache memory its not releasing it. Also if your increasing package cache, make sure you upping dbheap, otherwise the error might be misleading

Thanks for the reply,

Params on DB2 8.1.6a, are mentioned below:
APP_CTL_HEAP_SZ : 1512
SHEAPTHRES : 25000
APPLHEAPSZ : 20000
SORTHEAP : 2048
PCKCACHESZ : 10000
DBHEAP : 12000

These are almost double than 7.2 params.
DBHeap we have not increased. Can you please guide if we should change any of the above parameters? Also any idea about the DBHeap size which we should keep.

Also, can you mention any side-effects of 8.1.7 if you have faced.

Thanks again,
Harp

The only issues we had was with the parms not being large enough, and since we had lots of memory and it was 64 bit, it was no big deal. Also the way db2 allocates memory changed in V8, then in FP3, Fp5, and FP7. read through those depending on what level your at

Many Thanks David.