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