There are many design aspects for DB2 Temporal Tables that I have discussed in some of my previous blog entries. While reviewing the design of a recent data warehouse system, it became apparent that many index design points weren’t evaluated and were causing overall poor application DB2 performance. These same index design points are especially . . . → Read More: Three Essential DB2 Performance Design Points about DB2 Temporal Table Indexes
|
|
||
|
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 Traveling to different clients throughout the years as a DB2 consultant and seeing different database designs, development methodologies and tools being used provides some interesting technological perspectives. The complex nature of technology can muddy the issues within the business. Even as new buzzwords of cloud computing, Web 2.0 and other technologies come onto the horizon, . . . → Read More: DB2 Performance Tuning: Reliability, Availability and Scalability The annual North American IDUG conference was held in Anaheim, California and I always like going through the download of presentations to understand all the presentations I missed. Users, DB2 consultants and IBMers always provide great DB2 performance technical insights into how to get the most out of your environment. This year the conference DB2 . . . → Read More: DB2 Performance Tuning for LUW Feature: DB2 pureScale Adjust Your FREEPAGE and PCTFREE for GrowthThe proper free space settings along with the appropriate allocations detailed last week can help you avoid any DB2 reorgs and improve DB2 performance for a long time while your database grows. Properly setting your free space is . . . → Read More: DB2 Performance Maintenance — Avoid Database Reorgs Last week I talked about the basics of evaluating DB2 for z/OS and LUW compression. DB2 compression saves a huge amount of disk storage space and improves performance by eliminating I/O within your system. This week we talk about the performance implications of some other table space settings. If your database tables suffer performance problems, have bad SQL access paths and need constant reorgs, there are a number of table space settings that can help you avoid reorgs, minimize outages and help your . . . → Read More: DB2 Performance Maintenance – Saving Resources and CPU with the Correct Setting 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 DB2 Clean up – Close Out the PastAs I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week we look into the DB2 Plan and Package settings. These settings can . . . → Read More: DB2 Performance Maintenance – Get All the Cache DB2 Clean up – Close Out the PastAs I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week it’s recommended that you look into your various program’s plan and package . . . → Read More: DB2 Performance Maintenance – Trust But Verify DB2 Clean Up – Close Out the PastWithin every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. Test systems with unused databases, production jobs that need their schedule tweaked, reorgs for tables or indexes that need . . . → Read More: DB2 Performance Maintenance – Start Off the New Year Right! |
||
|
Copyright © 2012 Dave Beulke - All Rights Reserved | Privacy Policy | Refund Policy |
||
Find Me On