Enterprise Edition
Customer Service

Brother-Eagle Community

  • Visit/Join Now!
  • Get tips from other users!
  • Share your own tips, advice, and metric formulas!

DBI Products

Brother-Eagle® DB2 Performance
Advice: Pkg Overflows

PCKCACHESZ is a database configuration parameter which defines how much memory DB2 has available for storing packages and recently executed dynamic SQL. An SQL statement which is present in the package cache memory need not be re-loaded from the DB2 catalog (static SQL) or re-prepared (dynamic SQL).

PCKCACHESZ memory is drawn from DBHEAP memory. If the PCKCACHESZ is too small relative to the demand for concurrent execution of SQL statements, a package cache overflow can occur. Overflows draw upon "reserve" memory and slow down SQL performance.

If the number of "Pkg Overflows" is greater than zero, the size of the PCKCACHESZ should be increased by 10% increments until Package Cache Overflows stop occurring. Brother-Eagle will indicate a warning if two or more Package Cache Overflows occur and an alert if four or more overflows occur.


View full list of DB2 LUW advice topics