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 > Configure summarization and pruning without the Tivoli Enterprise Portal Server

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

Examples

This section contains examples of basic collection and summarization and pruning configuration.

Configuration and daily/hourly summarization

Collection is configured, and daily and hourly summarizations are set. No pruning has been specified. Use the SQL INSERT command.

Required:

  • TABNAME= Table Code

  • DAYSUM= -16822 (summarize daily)

  • HOURSUM=-16822 (summarize hourly) 

    INSERT INTO WAREHOUSESUMPRUNE (TABNAME,DAYSUM,HOURSUM) VALUES ('WTMEMORY','-16822','-16822');

Configuration, daily/hourly summarization, and daily/hourly pruning

Collection is configured, and daily and hourly summarizations are set. Pruning is specified for daily 3-month intervals and hourly 2-day intervals. Use the SQL INSERT command.

Required:

  • TABNAME=Table Code

  • DAYSUM=-16822 (summarize daily)

  • HOURSUM= -16822 (summarize hourly on)

  • PDAY= -16837 (prune daily)

  • PDAYINT=3 (prune interval)

  • PDAYUNIT= -16835 (prune monthly)

  • PHOUR = -16837 (prune hourly on)

  • PHOURINT= 2 (prune interval)

  • PHOURUNIT= -16836 (prune daily)

  • PRAW = -16837 (prune detailed on)

  • PRAWINT= 1 (prune interval)

  • PRAWUNIT= -16836 (prune daily) 

    INSERT INTO WAREHOUSESUMPRUNE 
(TABNAME,DAYSUM,HOURSUM,PDAY,PDAYINT,PDAYUNIT,PHOUR,PHOURINT,PHOURUNIT,PRAW,PRAWINT,PRAWUNIT) 
VALUES ('WTMEMORY','-16822','-16822','-16837',3,'-16835',2,'-16836','-16837',1,'-16836');

Remove daily summarization and pruning

In this example, collection has been configured, and daily and hourly summarizations have been set. You want to remove daily summarization and pruning. Use the SQL UPDATE command.

Required:

  • TABNAME= Table Code

  • DAYSUM= -16823 (summarize off)

  • PDAY= -16838 (prune daily off)

  • PDAYINT= 1 (prune interval to default)

  • PDAYUNIT= -16836 (prune daily) 

    UPDATE WAREHOUSESUMPRUNE SET DAYSUM='-16823', SET PDAY='-16838', SET PDAYINT=1, 
SET PDAYUNIT='-16836' WHERE TABNAME='WTMEMORY';

Remove collection entirely

Collection has been configured, and daily and hourly summarizations have been set. Set the collection to unconfigured by removing the entire row from the table, using the SQL DELETE command.

Required: TABNAME= Table Code 

    DELETE FROM WAREHOUSESUMPRUNE WHERE TABNAME='WTMEMORY';


Parent topic:

Configure summarization and pruning without the Tivoli Enterprise Portal Server

+

Search Tips   |   Advanced Search