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.


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

  1. 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.

  2. 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.

  3. 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

+

Search Tips   |   Advanced Search