IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Administrator's Guide > Tivoli Common Reporting > Create and maintain the dimension tables
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Configure the Summarization and Pruning agent to create and maintain the dimension tables
Configure the Summarization and Pruning agent to create and maintain the dimension tables required by Tivoli Common Reporting and IBM Tivoli Monitoring. The time dimension tables, TIME_DIMENSION, MONTH_LOOKUP, and WEEKDAY_LOOKUP, and the resource dimension tables, MANAGEDSYSTEM, MANAGEDSYSTEMLIST, MANAGEDSYSTEMLISTMEMBERS, are all created and maintained using this procedure.
- You must have IBM Tivoli Monitoring V6.3 Fix Pack 2 or later.
- Ensure that any historical collections and summarization needed for the MANAGEDSYSTEM table are enabled for each agent. See Configure historical data collection before you begin and your agent documentation.
- During this procedure the MANAGEDSYSTEM table is populated using information from the WAREHOUSETCRCONTROL table. The WAREHOUSETCRCONTROL table is created at the first successful start of the Summarization and Pruning agent or by running the scripts created when using the schema publication tool to generate the DDL.
It is the responsibility of each monitoring agent to put entries into the WAREHOUSETCRCONTROL table. Your monitoring agent might use scripts or manual steps to add their entries. For detailed information see your agent's user's guide.
For example, the OS agents reports package populates the WAREHOUSETCRCONTROL table during an installation step. This means if you want to use Tivoli Common Reporting with your OS agent reports, install the OS agents reports package before completing this task to ensure the required WAREHOUSETCRCONTROL entries are picked up. Note: You do not need to install the OS agent report package to enable historical collections.
- For DB2 LUW and DB2 z/OS, you must create a user in the Tivoli Data Warehouse database that has privileges to create tables and execute the stored procedure with the IBM_TRAM schema. The user must have SYSADM or DBADM authority to create an IBM_TRAM schema.
- For Oracle, you must create the IBM_TRAM user using the IBM_TRAM schema in the Tivoli Data Warehouse database, or you can create a user that has privileges to create tables and execute the stored procedure with the IBM_TRAM schema.
- For Microsoft SQL Server, you must create a user in the Tivoli Data Warehouse database that has privileges to create tables and execute the stored procedure with the IBM_TRAM schema.
This task configures the Summarization and Pruning agent to create and maintain the dimension tables. If the tables already exist, the Summarization and Pruning agent ensures the tables contain all the needed columns and then adds any missing columns. If a table already exists, but the index does not exist, the Summarization and Pruning agent will not create the missing index. If you have already customized your table data, your customized data is preserved.
Procedure
- Edit the Summarization and Pruning agent environment variable file.
- On the computer where the Summarization and Pruning agent is installed, in the Manage Tivoli Enterprise Monitoring Services application, right-click the agent and select Advanced → Edit ENV file.
- On the computer where the Summarization and Pruning agent is installed, change to the install_dir/config directory.
- Open the sy.ini file in a text editor.
Configure the following environment variables, then save the file:
- KSY_TRAM_ENABLE=Y
Indicates whether reporting integration is enabled. If enabled, the time dimension tables are created if they do not already exist. The default value is N.
If this variable is set to Y, and the time dimension tables do not exist, but the KSY_TRAM_USER and KSY_TRAM_PASSWORD are not set, then a warning message in the trace file and in the Summarization and Pruning agent Configuration workspace is returned indicating that the time dimension tables were not created.
- KSY_TRAM_USER=username
The reporting user that creates the time dimension tables. For all databases except DB2 LUW and DB2 z/OS the reporting user is set by default to IBM_TRAM.
For DB2 LUW and DB2 z/OS, because IBM_TRAM does not follow the user naming conventions for these databases, a different user name must be used. (In DB2 LUW a user name cannot start with IBM and in DB2 z/OS a user name cannot contain an underscore.) The user you create must have the necessary privileges to create an IBM_TRAM schema.
This variable is required only if the time dimension objects need to be created in the database.
- KSY_TRAM_PASSWORD=password
The password for the reporting user.
This variable is required only if the time dimension objects need to be created in the database.
- KSY_TRAM_TD_GRANULARITY=minutes
The number of minutes that the data is inserted into the TIME_DIMENSION table. The minimum value is 1. The default value is 5.
If the value specified is below the minimum value, the value is reset by the Summarization and Pruning agent at start up to the minimum value.
- KSY_TRAM_TD_INITIAL_LOAD=months
The amount of data in months to be loaded into the TIME_DIMENSION table when it is empty or first created. The minimum value is 1. The default value is 24 months.
If the value specified is below the minimum value, the value is reset by the Summarization and Pruning agent at start up to the minimum value.
- Reconfigure the Summarization and Pruning agent to enable reporting integration. You can use one of the following options:
- Reconfigure the Summarization and Pruning agent through Manage Tivoli Enterprise Monitoring Services enabling reporting integration.
For detailed steps, see the IBM Tivoli Monitoring Installation and Setup Guide.
- Reconfigure the Summarization and Pruning agent using the command-line interface enabling reporting integration.
For detailed steps, see the IBM Tivoli Monitoring Installation and Setup Guide.
- Reconfigure the Summarization and Pruning agent using remote deploy enabling reporting integration.
For detailed steps, see the IBM Tivoli Warehouse Summarization and Pruning Agent Reference.
- Restart the Summarization and Pruning agent.
Results
The dimension tables have been created and are now maintained by the Summarization and Pruning agent.The Summarization and Pruning agent only adds new systems to the MANAGEDSYSTEM table. This means if you have customized data, it is preserved.
What to do next
Verify the contents of the tables and ensure they have data for the upcoming month. The Summarization and Pruning agent maintains data one month ahead of the current month.You can view the Summarization and Pruning agent Configuration workspace for an overview of your configurations. Any errors encountered are also reported in this workspace. For detailed information about this workspace, see the IBM Tivoli Warehouse Summarization and Pruning Agent Reference.
You can create reports and queries based on your managed system groups.
Parent topic:
Create and maintain the dimension tables