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
How to Get Status of Running Backup and Restore in SQL Server? –...
Question: How to Get Status of Running Backup and Restore in SQL Server? Answer: One of the reasons I started my blog long ago was to have a repository of scripts which can be very useful by DBA duri...
Learn how to use Dimensional Views in Toad Data Point Workbook
Tired of just using pivots? Learn how to correctly use Dimensional Views as an analysis tools in Toad Data Point Workbook. To learn all about Toad Data Point Workbook – check out our Guide to ...
Modernizing Your Database Infrastructure
“If agile has been around since the 1990s and DevOps tools since the late 2000s, then why can’t our database development catch up with our application development?” Are people in your organisation as...
