Maximizing Your DB2 10 Upgrade ROI

Last week I wrote a blog talking about what items your shop can work on now to help prepare for DB2 10. It morphed somehow into a DB2 upgrade debate talking through many issues such as the merits of upgrades, release costs, management ideas and other opinions.

DB2 upgrades are not the same in any . . . → Read More: Maximizing Your DB2 10 Upgrade ROI

Plan Stability - Version 9 DB2 Performance Features - Part 20

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

Taking Advantage of Relational Technology Part 3

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