IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
New in Version 6.3
See the following changes to the Tivoli Data Warehouse component for Tivoli Monitoring V6.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. See Specify 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.
Migrate 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. 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. See Generate SQL for data warehouse tables.
Parent topic:
Tivoli Data Warehouse solutions