Archive for the 'DB2 Performance Tuning' Category

31 Aug

Combining Multiple MQTs to Improve SQL Optimization for DB2 Data Warehousing

Materialized Query Tables (MQTs) are really great for DB2 data warehousing situations and also for all types of reporting applications. Combining multiple MQTs is one technique that is good for providing all types of reporting capabilities and answers. By combining multiple MQTs, the DB2 SQL optimizer can sometimes automatically rewrite the queries from [...]

25 Aug

DB2 Version 10 and DB2 LUW: Redefining Performance

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 [...]

19 Jul

Get the SQL Cache Anyway–Even Without OSC

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 [...]

13 Jul

Improve Performance by Reducing Your Other Time

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 [...]

06 Jul

What DB2 Tools Do You Use Most?

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 and [...]

30 Jun

Free Tools for DB2 Help You Improve Access Performance

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 [...]

© 2010 Dave Beulke

Designed by NET-TEC Webspace -- Made free by Einladungskarten | Wintergarten | Ratenkredit
SEO Powered by Platinum SEO from Techblissonline