IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Editing the deletesingletable.xml file

Edit the MS_home/etc/deletesingletable.xml file to trim the tables included in the file:

  1. Change the commitcount setting from a default value of 2000 to something higher if you have large numbers of records to be deleted. Commitcount controls how often a transaction gets committed to a database. Commitcount is set in one place but applies to all tables included in the datatrim.xml file. 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. The useoracle setting is no longer used. Instead, the datatrim.sh script uses the JDBC driver to determine the type of database (IBM DB2 or Oracle) being used.

  3. To avoid database lock conflicts, do not have both the ENABLE_DATATRIMMER and the datatrim.sh script delete the same table. By default, VOLUMESTAT and MEMORY_DATA (if APAR PK13081 is applied) are included in both methods. Remove these tables from the datatrim.xml file when ENABLE_DATATRIMMER is set to true.

  4. In each table section, set either daystokeep or the startdate/enddate settings. If daystokeep is set, it will override the startdate/enddate values. For the REQUEST and METHODS tables, the settings must normally be the same values as those set for the request and method tables in the markdatadeleting.xml file.

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