| By Dave Beulke, on December 4th, 2012 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 By Dave Beulke, on June 14th, 2011 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 By Dave Beulke, on February 1st, 2011 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 By Dave Beulke, on February 5th, 2009 Another place to look for DB2 performance results is to research the use of compression. Using DB2 CompressionResearching 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 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 ReviewsHaving 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 By Dave Beulke, on October 1st, 2008 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 | |