IBM Tivoli Monitoring, Version 6.3

Types of table changes

The following types of table changes affect warehouse summarization:

Case 1 - New attribute added to an attribute group and defined as a primary key.
Case 2 - Existing attribute defined as a primary key or had primary key designation removed.
Case 3 - Moving some tables from 4K tablespaces to 8K tablespaces when using DB2® as the warehouse database.

Case 1 and Case 2 are primary key changes. In both cases, new summarization records will not match existing summarized data:

A new attribute was added to an attribute group and that attribute was defined as a primary key:
New summarization records will provide more accurate summarization or greater granularity than previous records. Existing summarization records are still available but contain less granular detail if default values are not assigned for the new primary keys.
An existing attribute was defined as a primary key or the primary key designation was removed:
If a new key was added, then the new summarization records will provide more accurate summarization or greater granularity than previous records. If a key was removed, then the new summarization records will provide less granularity than previous records, but with the intent of providing more meaningful summarization. Existing summarization records are still available.

Case 3 requires that you move some tables from 4K tablespaces to 8K tablespaces when using DB2 as the warehouse database to avoid errors during summarization and pruning processing.

Feedback