August 18, 2010

DB2 workload management

DB2 has added a lot of workload management features in recent releases. So when we talked Tuesday afternoon, Tim Vincent and I didn’t bother going through every one. Even so, we covered some interesting subjects in the area of DB2 workload management, including: 

Finally, Tim spoke of what I regard as the weirdest workload management requirement, one I also heard about from Netezza (but didn’t explicitly mention) in June. Sometimes, it seems, you simply don’t want queries to finish too fast. Why? Because if you give great performance when the machine is lightly loaded, then business users might expect that performance too when the machine is heavily loaded and you can’t deliver it. Apparently, in some environments it’s better to never deliver great query performance than it is to do so only inconsistently.

Comments

3 Responses to “DB2 workload management”

  1. Dave Shuttleworth on August 18th, 2010 11:00 am

    I recall having exactly the same discussions re the requirement to ‘slug’ a lightly loaded system way back when I was working with WhiteCross (now Kognitio WX2) databases back in the early 90′s.. and I’ve been asked to do something similar on a few occasions more recently by client IT management prior to a ‘go live’ on a new warehouse appliance.

    Some things don’t change!

    D.

  2. M-A-O-L » DWH Workload Management on August 26th, 2010 2:27 am

    [...] work has increased my awareness for Workload Managed in busy warehouses, so I read DB2 workload management with interest. And was chuckling whenI read this, because I can’t say I’ve never heard [...]

  3. Some thoughts on the announcement that IBM is buying Netezza | DBMS 2 : DataBase Management System Services on September 22nd, 2010 1:58 pm

    [...] been getting some DB2 briefings, which is why I’ve blogged about some specialized technical points from same. But I can’t yet say why the theoretically great-sounding data warehousing option [...]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.