Chapter 9. Managing data lifecyle with InfoSphere Warehouse 339
DB2 Workload Manager
DB2 Workload Manager (DB2 WLM) can be configured and used in
conjunction with storage group data tags to manage the resources assigned
to workloads that access data in a multi-temperature database.
For example, by creating a tag on a storage group, DB2 WLM can be
configured to assign a workload to a certain service subclass depending on
the storage group accessed, and then effect the resources and concurrency
rules applied to that workload. Using this approach you can change the
workload priority of a query based on the storage groups it touches. This
gives the administrator more control over queries that might access both hot
and cold data.
Temporal data ...