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
Managing connections in Toad for SQL Server
This video by Toad Expert Robert Pound demonstrates how to manage connections in Toad for SQL Server....
Overview of the dashboard feature in Toad for DB2 LUW
This video provides an overview of the dashboard feature in Toad for DB2....
