IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Administrator's Guide > Tivoli Common Reporting > Create and maintain the dimension tables > Manually creating and maintaining the dimension tables

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2


Create and populating the resource dimension table

Prepare the Tivoli Data Warehouse for Tivoli Common Reporting includes creating and populating the resource dimension table "ManagedSystem", which is required for running the Cognos reports and using the data models.

You must first configure historical data collection. For more information, see Configure historical data collection before you begin.


If your site runs the Tivoli Data Warehouse, each time you install one or more monitoring agents, you must update the warehouse's ManagedSystem table.

The following scripts use hardcoded user schemas. If you use a different schema, you must replace every instance of the hardcoded schema with the user you specified.


Procedure


Results

The resource dimension table is complete.


Parent topic:

Manually creating and maintaining the dimension tables

Previous topic: Create and populating the time dimensions tables


+

Search Tips   |   Advanced Search