Db2 for z/OS: CACHEPAC is Another ZPARM You Should Check

    Mar 29, 2018 1:07:00 AM by Robert Catterall

    Sometimes, the default value of a Db2 ZPARM parameter is changed to reflect new realities of Db2 workloads and of systems on which Db2 for z/OS runs. When that happens, a Db2-using organization may stick with the old default value for the ZPARM, and going that route can have a negative impact on the performance of the Db2 system. Case in point: CACHEPAC, the subject of this blog entry. I've blogged before about ZPARMs that are regularly set to sub-optimal values. I've also posted entries ...read more

     

    Tags: Toad for IBM DB2 IBM DB2 DB2 z/OS

    Robert Catterall

    Written by Robert Catterall