© 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.