IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions: common procedures > Run the warehouse agents autonomously > Configure a Summarization and Pruning Agent to run autonomously
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Configure summarization and pruning without the Tivoli Enterprise Portal Server
You can configure historical data collection and summarization and pruning using the Tivoli Enterprise Portal, or you can configure them directly in the warehouse database WAREHOUSESUMPRUNE table using SQL commands.
Table 1 contains descriptions of the columns in the WAREHOUSESUMPRUNE table. Insert one row for each attribute group to collect historical data, along with the values for any summarization and pruning settings. You do not need to set defaults for unused options; they are built into the table design. Varchar values must be enclosed in single quotes (' ')
Descriptions of the columns in the WAREHOUSESUMPRUNE control settings table
Name Type Description TABNAME VARCHAR (40) NOT NULL PRIMARY KEY The short table name. In the application support file, this is the value of TABLE. Review the application support file associated with each agent for the TABLE names. YEARSUM VARCHAR (8) DEFAULT ‘-16823’ Yearly Summarization on (-16822); off (-16823) QUARTSUM VARCHAR (8) DEFAULT ‘-16823’ Quarterly Summarization on (-16822); off (-16823) MONSUM VARCHAR (8) DEFAULT ‘-16823’ Monthly Summarization on (-16822); off (-16823) WEEKSUM VARCHAR (8) DEFAULT ‘-16823’ Weekly Summarization on (-16822); off (-16823) DAYSUM VARCHAR (8) DEFAULT ‘-16823’ Hourly Summarization on (-16822); off (-16823) HOURSUM VARCHAR (8) DEFAULT ‘-16823’ Daily Summarization on (-16822); off (-16823) PYEAR VARCHAR (8) DEFAULT ‘-16838’ Yearly Pruning on (-16837); off (-16838) PYEARINT SMALLINT DEFAULT 1 Number of units (years, months, or days) PYEARUNIT VARCHAR (8) DEFAULT ‘-16834’ Type of Unit. Years (-16834), Months (-16835), Days (-16836) PQUART VARCHAR (8) DEFAULT ‘-16838’ Quarterly Pruning on (-16837); off (-16838) PMON VARCHAR (8) DEFAULT ‘-16838’ Monthly Pruning on (-16837); off (-16838) PMONINT SMALLINT DEFAULT 1 Number of units (years, months, or days) PMONUNIT VARCHAR (8) DEFAULT ‘-16835’ Type of Unit. Years (-16834), Months (-16835), Days (-16836) PWEEK VARCHAR (8) DEFAULT ‘-16838’ Weekly Pruning on (-16837); off (-16838) PWEEKINT SMALLINT DEFAULT 1 Number of units (years, months or days) PWEEKUNIT VARCHAR (8) DEFAULT ‘-16835’ Type of Unit. Years (-16834), Months(-16835), Days(-16836) PDAY VARCHAR (8) DEFAULT ‘-16838’ Daily Pruning on (-16837); off (-16838) PDAYINT SMALLINT DEFAULT 1 Number of units (years, months, or days) PDAYUNIT VARCHAR (8) DEFAULT ‘-16835’ Type of Unit. Years (-16834), Months (-16835), Days (-16836) PHOUR VARCHAR (8) DEFAULT ‘-16838’ Hourly Pruning on (-16837); off (-16838) PHOURINT SMALLINT DEFAULT 1 Number of units (years, months, or days) PHOURUNIT VARCHAR (8) DEFAULT ‘-16836’ Type of Unit. Years (-16834), Months (-16835), Days (-16836) PRAW VARCHAR (8) DEFAULT ‘-16838’ Detailed Pruning on (-16837); off (-16838) PRAWINT SMALLINT DEFAULT 1 Number of units (years, months, or days) PRAWUNIT VARCHAR (8) DEFAULT ‘-16836’ Type of Unit. Years (-16834), Months (-16835), Days (-16836)
- Examples
This section contains examples of basic collection and summarization and pruning configuration.
Parent topic:
Configure a Summarization and Pruning Agent to run autonomously