Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

© Copyright IBM Corp. 2012. All rights reserved. 237

Chapter 6. Managing complex query

workloads in an operational

warehouse environment

In this chapter we discuss the challenges faced by complex query workloads in

an operational business intelligence (BI) environment, and explain how you can

address these challenges using Optim Performance Manager in conjunction with

DB2 workload manager (DB2 WLM).

An operational data warehouse that must facilitate fundamentally different use

cases and maintain performance objectives for each can be described as having

a complex query workload. Short tactical queries such as fraud assistance or

client care assistance applications that target small subsets of rows and must

complete in two or three seconds are processed alongside decision support and

long-running analytics queries that must complete in minutes or hours. Each task

is important to the business and each must finish within the objectives set.

Using DB2 WLM in conjunction with Optim Performance Manager can help you

define structures that resolve situations where unrestricted access to resources

by complex query workloads with mixed priorities can cause the system to

become unresponsive.

6

238 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

The recommended best practices for implementing a comprehensive DB2 WLM

configuration are discussed in the paper DB2 best practices: Implementing DB2

workload management in a data warehouse, which can be found on the IBM

developerWorks® site:

http://www.ibm.com/developerworks/data/bestpractices/workloadmanagement/

DB2 WLM is implemented as part of the DB2 database software, and this default

implementation is referred to as stage 0. The Workload Manager Configuration

dashboard in Optim Performance Manager can be used to automatically apply a

stage 1 implementation of DB2 WLM, which you can then build on through

stages 2 and 3.