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:

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

+

Search Tips   |   Advanced Search