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 use extended properties to document a SQL Server database
ApexSQL Doc, a documentation tool for SQL Server, uses extended properties stored in the SQL Server database to display descriptions of SQL database objects. With the Extended Property Editor feature,...
How to use the Batch Optimizer with Rule Based Optimizer
This tip covers using the batch optimization process when your database is set to run with the rule based optimizer. In the Batch Optimizer in Quest SQL Optimizer for Oracle you may notice that the o...
Toad Data Point Professional Edition with Analytics demo
Trying to decide between Toad Data Point editions? Watch this Toad Data Point Pro Edition with Analytics product demo to review features. A free 30-day Trial of Toad Data Point can be downloaded...
