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