This paper describes the best practices for configuring
MicroStrategy®software to use the workload management (WLM)
features of IBM® DB2®9.5 for Linux®, Unix®, and Windows®.
A critical element of managing an enterprise business
intelligence (BI) systemis effective workload management (WLM) –
applying the right RDBMSresources to the right user requests. DB2
9.5 provides the DB2 WorkloadManager, which introduces a new
workload management paradigm thatmakes it easier to monitor and
control active work in the system.
MicroStrategy software integrates easily with these new WLM
features so thatinsight and control are extended to the BI
system.
This document is organized as follows. The first part reviews
importantconcepts of how MicroStrategy software submits work to DB2
9.5 and howDB2 9.5 manages workloads. The second part of the
document thendescribes a detailed example of how MicroStrategy and
DB2 9.5 can beconfigured to achieve workload management objectives
typical of aMicroStrategy application.
