Plan Stability - Version 9 DB2 Performance Features - Part 20

By Dave Beulke, on March 16th, 2010

DB2 Version 9 offers a new way to handle testing out a new version of a DB2 application through the Plan Stability enhancements. The Plan Stability enhancements offer a way to save a static DB2 access package for an application and then BIND a new one. If the access package is not as efficient, Plan . . . → Read More: Plan Stability – Version 9 DB2 Performance Features – Part 20

Leave a comment   DB2 Performance   , , , ,  

Taking Advantage of Relational Technology Part 3

By Dave Beulke, on January 14th, 2009

Last time we talked about excess tablespace scans, list prefetch and index scans. Let’s look further into potential application performance issues.

Lack of Data Access Reviews

Having good application and SQL review processes in place for testing, and quality assurance are vital for overall guarantees of application performance. One of the best ways to facilitate . . . → Read More: Taking Advantage of Relational Technology Part 3

Leave a comment   DB2 and Java, DB2 Performance   , , , ,