IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
deletesingletable.xml
The deletesingletable.xml file is found in the MS_home/etc directory.
To schedule deleting records in the database, set the following property:
Property applies to all tables
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 commit count.
Properties are applied to each individual table, such as PMISTATS, SERVERSTATS, and VOLUMESTAT.
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
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.
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.
Parent topic:
Data Trimmer properties files