IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
deleterelatedtables.xml
The deleterelatedtables.xml file is found in the MS_home/etc directory.
To schedule deleting records in the REQUEST and METHOD tables, set the following properties:
commitcount
Number of records to be committed to database in a transaction (commitcount). The default for commitcount is 2000. The time taken to delete commitcount number of rows is mentioned in the datatrim.log. This value must normally be less than the lock timeout value in the database, which is 60 seconds by default. If the time taken to delete commitcount number of rows is greater than data base lock timeout value (60 seconds), decrease the commit count.
delayinterval
Interval in seconds between successive deletes to avoid table locking, when Managing Server is running. Default value is 15 seconds. For faster deletion and when Managing Server is processing a light load of data, decrease delayinterval. When Managing Server is processing a large load of data and if there are lock timeout exceptions in the ArchiveAgent logs, increase delayinterval.
daystokeep
Number of days to keep the data (daystokeep). 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.
startdate
Start date for deleting data (startdate). 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. If the daystokeep property is specified, then this property will not be used.
enddate
End date for deleting data (enddate). 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. If the daystokeep property is specified, then this property will not be used.
Keep in mind that the startdate and enddate specified for the request table will also apply to the method table because they are tied together by the request_id.
Parent topic:
Data Trimmer properties files