Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

346 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Although the movement of data is an asynchronous task, the data remains

available to applications during the process. Because the

TSFACTDATA_2010Q1 table space inherits its media attributes from its storage

group, its media attributes now are based on storage group SG_COLD.

Monitor the progress and the status of the operation using the

MON_GET_REBALANCE_STATUS table function as shown in Example 9-2.

Example 9-2 Monitoring progress of the table space rebalance process

SELECT tbsp_name, rebalancer_status, rebalancer_extents_remaining,

rebalancer_extents_processed FROM TABLE (MON_GET_REBALANCE_STATUS(NULL, -1))

The operation can be suspended or resumed where required, as shown in

Example 9-3.

Example 9-3 Monitoring progress of the table space rebalance process

-- Suspend the rebalance process

ALTER TABLESPACE tsfactdata_2010q1 REBALANCE SUSPEND

-- Resume the rebalance process

ALTER TABLESPACE tsfactdata_2010q1 REBALANCE RESUME

The movement of data from one storage group to another can be throttled as a

utility using the UTIL_IMPACT_LIM and UTIL_IMPACT_PRIORITY configuration

parameters. Throttling database operations using these configuration

parameters throttles CPU processor usage; it does not control I/O usage.

Avoid moving too many table spaces at any one time because there is an effect

on both the source and target storage group paths.

9.3.1 How active is the data

We have discussed how data ages and how to manage and order data by age.

However, it is equally important to understand the temperature of data by how

often it is used.

By understanding how active your data is, you can further manage the physical

implementation of your data warehouse. Ingesting and maintaining inactive data

is a poor value proposition.

The SQL statements dashboard in Optim Performance Manager has two tabs,

the Top Individual Executions tab and the Execution summary tab. The