Upgrading your warehouse includes making the following types of
changes:
- Case 1 - New attribute is added and is designated as a primary
key
- New attribute and a default value must be added to the raw table
and the summarization tables.
If the attribute group name is not
too large for the underlying database, the table name corresponds
to the attribute group name. If the attribute group name is too long,
a short name is used. The mapping of attribute group names to table
names is stored in the WAREHOUSEID table.
- Case-1 scripts that perform the following actions are provided
to assist in this change:
- Alter existing raw tables
- Alter existing summary tables
- Drop existing summary views
- These changes must be done before the monitoring agent is started
and begins exporting data to the Warehouse Proxy agent.
- Case-2 - Existing attributes are changed to either add or remove
primary key designation.
- Existing data is of limited value and should be deleted.
- Case-2_Truncate scripts that perform the following actions are
provided to assist in this change:
- Remove all records from existing summary tables, preserving existing
table definitions
- Delete the raw data marker allowing raw data to be resummarized
- Case-2_Drop scripts that perform the following actions are provided
to assist in this change:
- Drop existing summary views
- Drop existing summary tables
- Delete the raw data marker allowing raw data to be resummarized
- These changes are optional, but result in more accurate summarized
information.
- Case 3 - Move tables from 4K tablespace to 8K tablespace for selected
agents
- Special processing for selected agents, to move tables from a
4K tablespace to an 8K tablespace.
- Individual scripts are provided for each summary table to be changed.