New in Version 6.3

Tivoli Data Warehouse range partitioning

Range partitioning is a database data organization feature that can significantly improve pruning and query performance in large Tivoli Data Warehouse databases. For more information and the associated configuration parameters, see Tivoli Data Warehouse range partitioning.

Specify the tablespaces where tables and indices are created

Beginning with Version 6.3, you can configure the Warehouse Proxy Agent and the Summarization and Pruning Agent so that created Tivoli Data Warehouse tables and indices are located in default table spaces. Tablespaces can be specified for partitioned or non-partitioned tables. This new function is independent of partitioning. For more information, see Specifying where tables and indices are created.

New Summarization and Pruning Agent workspace

A new workspace, Table Partition Statistics, is available from the Statistics Navigator item. This workspace provides statistics about the table partitions if table range partitioning is enabled. You can see the number of partitions created, added, removed, or rotated per table per product.

Migrating non-partitioned tables to partitioned tables using the Schema Publication Tool

The schema publication tool allows you to generate SQL scripts with tables and indices created in default table spaces. This new implementation in Tivoli Monitoring V6.3 provides a means for you to migrate existing non-partitioned tables to partitioned tables. This feature allows you to benefit from the performance improvements of partitioned tables. For more information, see IBM Tivoli Monitoring Administrator's Guide.

Filter by table in Schema Publication Tool

You can now filter by table in any mode of the Schema Publication Tool. For more information, see Generating SQL for data warehouse tables.