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
Related Articles
Getting Started with Toad for DB2 Chapter 5 The Basics – Filtering
Toad DB2 Expert, Jeff Podlasek demonstrates how to use filtering within the Database Explorer to limit the objects being displayed....
Easily Evolve Your Database with Flyaway
We’ve always had features to version our code, but it’s been harder to version the objects in our databases. With the increasing use of DevOps and continuous delivery, the pain of managing database sc...
How to comment out clauses in the Toad Data Point query builder
This video demonstrates how to comment out clauses in the Toad Data Point query builder....
