Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Package Cache - Sanity check

    LUW 9.1 FP4a

    Hey all,

    I'm seeing my package cache hit ratio dropping to 60-70% from time to time but I have STMM on and the PCKCACHESZ = AUTOMATIC. Now when I check it the cfg says it's constantly at 524288 (which is the maximum value!!). I figure that to be 2GB, which roughly means the package cache must need about 3GB during certain times, yea?

    Now my entire database is only about 20GB... does this not add up to you guys either?

  2. #2
    Join Date
    Jul 2006
    Pune , India
    Try to change some of the major queries fired too often to be dynamic/Parametized
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Aug 2001
    If your queries are not parameterized, then it doesn't matter how big your package cache is ... every statement has to be prepared and inserted into the cache ...
    Last edited by sathyaram_s; 02-15-12 at 12:34. Reason: typo
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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