I did my DB2 LUW migration to DB2 LUW Version 10 and now it’s time to take advantage of all the great DB2 LUW Version 10 features. The one that is on the top of my list is the new Adaptive Compression. Adaptive Compression is the newer, better DB2 LUW compression. The new Adaptive DB2 . . . → Read More: DB2 LUW Compression: Be Adaptive for Performance and Storage Savings
As I continued to review the IDUG presentations from this year, DB2 performance and RAS (Reliability, Availability and Scalability) came to mind. The DB2 LUW presentation by Dale McInnis and Katherine Kurtz’s “Best Practices for Building a Database Recovery Strategy for Your InfoSphere Warehouse Database” popped out at me. I’ve seen many of Dale’s presentations . . . → Read More: DB2 Performance Tuning: Reliability, Availability and Scalability — IDUG Resources
Thank you all for the comments about last week’s blog. With the queries from last week you were able to see the various settings within your PLAN and PACKAGE environment and some were surprised with what they found. Some of you discovered extreme or a few rogue situations within your plan and package settings.
This . . . → Read More: DB2 Performance Maintenance – Saving All the Money and Space Possible
Another place to look for DB2 performance results is to research the use of compression.
Using DB2 Compression
Researching another aspect of one of the main tables showed that the table was not leveraging DB2 compression. Since it has almost a million rows, a long record length and was probably referenced more for retrieval than . . . → Read More: Effects of Compression on DB2 Performance
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
Every client is different and working in a variety of different environments helps me understand different systems, applications and DB2 database design performance aspects and what works and doesn’t work. Over the next few weeks, I’ll be highlighting for you how to improve the DB2 performance . . . → Read More: DB2 Case Study Introduction: DB2 Performance and Throughput