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 performance. These same index design points are especially important . . . → Read More: Three Essential DB2 Temporal Table Index Performance Design Points
|
|
||
|
As I continue to review the IDUG presentations from this year, performance and RAS 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 over the years on HADR, . . . → Read More: DB2 Performance Tuning: Reliability, Availability and Scalability — IDUG Resources Traveling to different clients throughout the years 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, it’s still the standard . . . → 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, 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 LUW . . . → Read More: DB2 Performance Tuning for LUW Feature: DB2 pureScale DB2 Materialized Query Tables (MQTs) are really great for DB2 data warehousing situations and also for all types of reporting applications. Combining multiple DB2 MQTs is one technique that is good for providing all types of reporting capabilities and answers. By combining multiple DB2 MQTs, the DB2 SQL optimizer can sometimes automatically rewrite the . . . → Read More: Combining Multiple MQTs to Improve SQL Optimization for DB2 Data Warehousing The beta of DB2 10 for z/OS continues to progress with the early indications that the relative performance processing bar is definitely being raised in this next version. Early DB2 10 beta customers are truly experiencing 5-10% performance improvements out of the box. Some are even experiencing greater improvements because their unique application processing fits . . . → Read More: DB2 Version 10 and DB2 LUW: Redefining Performance It seems that I hit a nerve when I was talking about DB2 tools. It seems many shops are upset at the rising costs of third party tools. IBM’s responses of some free tools that have limited capabilities are also getting limited enthusiasm. What has been interesting is there really seems to be support for . . . → Read More: Get the SQL Cache Anyway–Even Without OSC Performance tuning is always different for every system and application. In addition, the different DB2 LUW DBM configurations and z/OS zParms provide customizable options to improve your system and application performance mix. These parameters are usually standard with the DB2 LUW AUTOCONFIGURE options. The DB2 z/OS standard settings from years of previous versions and suggestions . . . → Read More: Improve Performance by Reducing Your Other Time The comments about Optimization Service Center (OSC) and the free Data Studio were great last week. Sorry I could not reply because I am working with clients on their DB2 performance issues. I’m only able to look through the DB2-L Digest in the evenings. I agree that IBM has a great free product in OSC . . . → Read More: What DB2 Tools Do You Use Most? Analyzing SQL access performance is difficult without any tools. The Optimization Service Center (OSC) is a great tool and resource within DB2 V9 for z/OS. This tool helps you with the cost of the SQL, Visual Explain of the access path and provides the ability to dump and then look through the Dynamic Statement Cache . . . → Read More: Free Tools for DB2 Help You Improve Access Performance  Leave a comment  DB2 Performance Tuning  Data Studio Administrator, DB2 9 for z/OS, DB2 Estimator, DB2 LUW, DB2 Performance, DB2 Query Performance, DB2 Version 9 for z/OS, DBRM Finder, Dynamic Statement Cache, IBM's Data Studio, Optimizer Service Center, OSC, SQL Access Performance, Text Search Finder, Visual Explain |
||
|
Copyright © 2012 Dave Beulke - All Rights Reserved Privacy Policy |
||