IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Editing the deleterelatedtables.xml file

Edit the MS_home/etc/deleterelatedtables.xml file to mark the rows in the REQUEST and METHOD tables to be deleted:

  1. Commitcount controls the number of records to be committed to a database in a transaction. Change the commitcount setting from a default value of 2000 to something higher if you have large numbers of records to be deleted. Commitcount is set in one place but applies to both the REQUEST and METHOD tables. After executing datatrim.sh examine datatrim.log file and verify that time taken to delete commitcount number of rows is less than 60 seconds, if not decrease commit count value.

  2. In each table section, set either daystokeep or the startdate/enddate settings. If daystokeep is set, it will override the startdate/enddate values.

    1. daystokeep is the number of days to keep the data. To trim all data up to 7 days ago, then daystokeep=7. For example, if today is July 8, 2004, and you specify daystokeep=7, the Data Trimmer will complete the following tasks:

      • Find out what the current date is (July 8, 2004).

      • Keep today's data.

      • Start counting 7 days back from 24 hours ago yesterday (July 7, 2004) – July 1st, 2004

      • Delete all data up to June 30th, 2004, inclusive.

      • Data from July 1st onwards is kept.

    2. startdate is the start date for deleting data. Use this to specify a time period for deleting data. To delete from and not include January 1 2003, enter startdate= 01/01/03 00:00:00.

    3. enddate is the end date for deleting data. Use this to specify a time period for deleting data. To delete up to and not including March 31, 2003, enter enddate=03/31/03 00:00:00.


Parent topic:

Run the Datatrim.sh script

+

Search Tips   |   Advanced Search