Workload management
The purpose of workload management is to ensure that limited system resources are prioritized according to the needs of the business. Work that is designated as being of greatest importance to the business is given the highest priority access to system resources. In a data warehouse environment, this means that users running online queries can expect predictable and acceptable response times at the possible expense of long running batch jobs.
It is possible to monitor and manage the work at every stage of processing, from the ...

Get Leveraging DB2 10 for High Performance of Your Data Warehouse now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.