IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Administrator's Guide > Manage historical data > Summarization and pruning configuration

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

Change global configuration settings

Use the Configure Summarization and Pruning Agent window to change system-wide configuration settings for data summarization, pruning, or collection.


Complete these steps to edit the summarization and pruning agent configuration:


Procedure

  1. In Manage Tivoli Enterprise Monitoring Services, right-click Summarization and Pruning agent.

  2. Click on Reconfigure.

  3. Click OK in the Warehouse Summarization and Pruning Agent: Advanced Configuration window.

  4. Click OK in the next window.

  5. Click Yes in the Warehouse Summarization and Pruning Agent window to configure the Summarization and Pruning Agent.

  6. Enter the Tivoli Data Warehouse database and Tivoli Enterprise Portal server information in the Sources tab:

    1. In the JDBC drivers field, click Add to invoke the file browser window to select your JDBC driver. Click OK to close the browser and add the JDBC drivers to the list You can also highlight an entry in the JDBC drivers list and click Delete to remove a driver. This gives you the ability to collect JDBC drivers to communicate with the Tivoli Data Warehouse database. JDBC drivers are installed separately and each database provides a set of these JDBC drivers.

      • If the Tivoli Data Warehouse database is on an operating system such as UNIX, find the directory where DB2 is installed and, in the jdbc drivers directory, select the db2jcc.jar and db2jcc_license_cu.jar files. For example, <db2_installdir>/java/db2jcc.jar and <db2_installdir>/java/db2jcc_license_cu.jar.

      • If the Tivoli Data Warehouse database is on MS SQL Server 2000 or 2005, install the MS SQL Server 2005 JDBC driver from the Microsoft SQL Server website. You will need the sqljbc.jar file; see the installation instructions for your operating systems from Microsoft to locate the file.

      • If the Tivoli Data Warehouse database uses Oracle, use the ojdbc14.jar file. The location on Windows is %ORACLE_HOME%\jdbc\lib; the location on operating systems such as UNIX is $ORACLE_HOME/jdbc/lib.

    2. In the drop down list, select the type of database for the Tivoli Data Warehouse.

    3. If not correct, enter the Tivoli Data Warehouse URL, Driver, Schema, User ID and password.

      During the configuration of the warehouse proxy, a database user (called ITMUser by default) is created. The User ID that you enter here must match that database user.

    4. Click Test database connection to ensure you can communicate with the Tivoli Data Warehouse database.

    5. Enter the Tivoli Enterprise Portal Server Host and Port, if you do not want to use the defaults. The TEP Server Port field is numeric only.

  7. Select the scheduling information in the Scheduling tab:

    • Fixed – Schedule the agent to run every x days and at what time (at least 5 minutes from now if you want it to run right away). The default is to run every day at 2:00 AM.

    • Flexible – Schedule the agent to run every x minutes. In the text box above the Add button, you can specify the times when the agent should not run, using the format HH:MM-HH:MM (24-hour clock, such as 12:00-20:00 to not run between 12:00 PM and 8:00 PM), and click Add to add the time range to the Except box.

    If you select Fixed, the Summarization and Pruning agent does not immediately perform any summarization or pruning when it starts. It performs summarization and pruning when it runs. It runs according to what is set on the Scheduling tab. If you select Flexible, the Summarization and Pruning agent runs once immediately after it is started and then at the Run every interval except during any blackout times.

  8. Specify Shift Information and Vacation Settings in the Work Days tab:

    1. Select Sunday or Monday as the day the Week starts on.

    2. If you want shifts, select Specify shifts. The default settings for this field are listed in the Peak Shift Hours box on the right side of the window. Change these settings by selecting the hours you want in the Off Peak Shift Hours box and clicking the right arrow button to add them to the Peak Shift Hours box.

      Specifying shifts is not recommended because it increases the amount of disk space needed on the data warehouse and the amount of processing time needed for summarization and pruning.

      Restriction: Changing the shift information after data has been summarized can create an inconsistency in the data. Previous data collected and summarized cannot be recalculated with the new shift values.

    3. To change your vacation settings, select Specify vacation days. Click Yes or No to specify weekends as vacation days. Select Add to open a calendar, then select the vacation days to add. The days selected display in the box below the Select vacation days field. To delete any days you have previously chosen, select them and click Delete.

      Right-click to select the month and year.

  9. Select the options you want in the Log Parameters tab. This tab defines the parameters for pruning the log tables populated by the warehouse proxy and the summarization and pruning agent.

    1. Select Keep WAREHOUSEAGGREGLOG data for to prune the WAREHOUSEAGGREGLOG table, which is populated by the summarization and pruning agent. After enabling this option, specify the number of days, months, or years to keep data in the table. Data older than the specified time interval will be deleted by the summarization and warehouse pruning agent.

    2. Select Keep WAREHOUSELOG data for to prune the WAREHOUSELOG table, which is populated by the warehouse proxy. After enabling this option, specify the number of days, months, or years, to keep the data in the table. Data older than the specified time interval will be deleted by the summarization and pruning agent.

  10. In the Additional Parameters tab select these options:

    1. Specify the maximum rows that can be deleted in a single database transaction. The values are 1 through n. The default is 1000.

    2. Specify the age of the data that you want summarized in the Summarize hourly data older than and Summarize daily data older than fields. Values are 0 through n. The default is 1 for hourly data and 0 for daily data.

    3. Choose the time zone you want to use from the Use timezone offset from drop down list. If the Tivoli Data Warehouse and agents that are collecting data are all not in the same time zone, and all the data is stored in the same database, use this option to identify the time zone you want to use.

    4. Specify the number of concurrent execution threads that will be used when the summarization and pruning agent is processing data in the Number of Worker Threads. The recommended value is twice the number of CPUs. More threads might allow the summarization and pruning agent to finish faster, but will use more resources on the machine that is running the summarization and pruning agent and will use more database resources such as connections and transaction log space.

    5. The summarization and pruning caches the most recent errors that have occurred in memory. This information is provided in an attribute group and can be viewed in workspaces that are provided with the summarization and pruning agent. The Maximum number of node errors to display setting specifies the maximum number of errors to store in memory. Only the most recent errors are kept. Once the limit is reached, the oldest errors are dropped.

    6. The summarization and pruning caches information about the most recent runs that were performed. This information is provided in an attribute group and can be viewed in workspaces that are provided with the summarization and pruning agent. The Maximum number of summarization and pruning runs to display setting specifies the maximum number of runs to store in memory. Only the most recent runs are kept. Once the limit is reached, the oldest runs are dropped.

    7. The summarization and pruning agent periodically checks that it can communicate with the data warehouse database. The database connectivity cache time setting determines how often to perform this check.

    8. To improve performance, the summarization and pruning agent batches updates to the data warehouse database. The Batch mode parameter specifies how the batching will be performed. The two options are single managed system and multiple managed systems.

  11. Click any of these buttons: Save after you have all your settings correct; Reload to reload the original values; or Cancel, at any time, to cancel out of the Configure Summarization and Pruning Agent window.


Parent topic:

Summarization and pruning configuration

+

Search Tips   |   Advanced Search