Hi Sachin,
0. Do a reorg and Bind for the complete database. After this try to execute the stored proc. If not
proceed to step below [1].
1. Check the value of MAXAPPLS by executing the command
db2 "get db cfg for <db-name>"
If it is set to a value, then set it to MAXAPPLS = AUTOMATIC by executing
db2 update db cfg for "<db-name>" using "MAXAPPLS" "AUTOMATIC"
Let me know how it goes.
Good luck
Partha

-----Original Message-----
From: Sachin Kumar [mailto:db2udbdba-ezmlmshield-x16888700.[Email address protected]
Sent: Wed 12/29/2004 11:53 PM
To: LazyDBA Discussion
Cc:
Subject: Urgent SQL0973N -- PCKCACHESZ Issue



hi all,

i am having following issue.

i have restored a database from production into a new production
server. All went smooth.

no errors were there, All database objects are fine and none
are invalid.

I can query data from tables and views but when i execute a procedure
following error comes up .

no procedure is executing

C:\>db2 call proc_cms_checkbal('GURG000001',?)
SQL0973N Not enough storage is available in the "PCKCACHESZ" heap to
process
the statement. SQLSTATE=57011


please let me know the all possible workarounds for it


help awaited

regards
Sachin



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page