Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Chapter 6. Managing complex query workloads in an operational warehouse environment 253

The Workload Manager Service Subclass report can also be used to review

details by Service superclass and Service subclass. Figure 6-14 shows the

report parameter window.

Figure 6-14 Workload Manager Service Subclass report

6.4 Understanding query workloads in your

environment

A system with a complex query workload can become unresponsive if access to

resources is not managed in a prudent way. You can avoid such unresponsive

situations by using careful planning and workload management techniques.

A

query workload can be defined as a set of queries that access the same set of

tables and retrieve similar result sets. A query workload can be identified through

shared attributes such as being through the same client application interface or

through shared connection data which might include application ID, user ID,

source IP address, client ID, or client version.

Use these simple guidelines to begin the process of being able to manage the

query workloads in your environment:

򐂰 Define service level objectives that align with each query workload. (example:

elapsed time with workload filter)

򐂰 Allow queries to begin processing when resources are available for the query

to complete.