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
Common misconception about how Oracle handles deadlocks
Introduction In today's blog post, I'd like to uncover a common misconception about how Oracle handles deadlocks, but first let's talk about what deadlock is. Deadlock is a locking scenario that occur...
Toad Data Modeler Reverse Engineering & Convert Model Wizards
We can easily create a data model of an existing database schema using the Toad Data Modeler Reverse Engineering wizard and then using the Convert Model Wizard to convert that model to another databas...
What is automated SQL tuning? Time saving DBA tips.
SQL tuning is needed because structured data is here to stay—even as unstructured data becomes more prevalent and important. Quest Software® partnered with Unisphere Research to study the virtual aval...
