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
Oracle Multi-tenant Application Containers – Part II – Create...
Overview As I discussed in my last article Oracle Multi-tenant Application Containers Part-I, Oracle Database 12.2.0.1 introduces the concept of multi-tenant application containers that enable many PD...
Using Amazon Redshift with Toad Data Point – Part I
Introduction Amazon Redshift is a data warehouse and data analytics service that makes used of standard SQL for running complex analytical queries on structured data. Redshift contrasts with relationa...
What’s New in Toad for DB2 v6.1
Toad for IBM DB2 v6.1 is now available. Like the v6 release, we made a lot of nice improvements – many of which were customer ideas! We really appreciate user contributions. New/Updated Features...
