IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Schema Publication Tool
The schema publication tool is an SQL editor that allows you to generate SQL statements and create your database objects.
With the schema publication tool you can perform the following tasks:
- Generate the SQL statements needed to create the database objects required for initial setup of the Tivoli Data Warehouse.
- Create the necessary database objects whenever either historical collection is enabled for additional attribute groups or additional summarizations are enabled. This is referred to as running the schema publication tool in updated mode. Updated mode is also used if agents are upgraded to a new release. An upgrade might add new columns to existing tables and the schema publication tool will generate the appropriate alter table statements.
- Generate SQL for data warehouse tables
You can use the schema publication tool to generate the SQL statements needed to create the database objects required for initial setup of the Tivoli Data Warehouse.
- Use the Schema Publication Tool for database compression
The Schema Publication Tool allows you to generate DDL scripts that can be used against a database capable of compression.