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:

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

+

Search Tips   |   Advanced Search