Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Unanswered: Heap Error in DB2 UDB 8.1.6a

    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

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    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
    David Quigley

  3. #3
    Join Date
    Sep 2004
    Posts
    5
    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

  4. #4
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    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
    David Quigley

  5. #5
    Join Date
    Sep 2004
    Posts
    5
    Many Thanks David.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •