Version 10 DB2 Plan and SQL Optimization Preservation

Leverage DB2 Version 9 BASIC and EXTENDED Plan Stability Features

Last week I talked about leveraging the DB2 Version 9 BASIC and EXTENDED plan stability features. I also commented that if you don’t have DB2 9 and are coming from DB2 Version 8 to DB2 10 that you can still save your access plans. If . . . → Read More: DB2 10 SQL Optimization Preservation

Maintaining DB2 Query Performance Tuning within DB2 10

Three Things to Do to Retain Your DB2 Query Performance

Everyone is really wondering whether the performance improvement numbers are really true for DB2 10. The answer is a big “YES” according to the majority of the DB2 10 Beta customers. The performance figures are true and sometimes better than the 5-10% saving right out . . . → Read More: Maintaining DB2 Query Performance Tuning within DB2 10

DB2 10 Performance Solutions

Being an IT consultant is always interesting especially when visiting a variety of shops around the country analyzing their designs, practices and performance. The major theme that comes through all these shops is that every company is trying to save money and trim their IT budget. These cost savings efforts are slashing budgets by about . . . → Read More: DB2 10 Performance Solutions