IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
Run the Datatrim.sh script
The datatrim.sh script is a command-line utility that can be scheduled or can be run manually to trim data from the database that is no longer needed. The properties files are MS_home/etc/deletesingletable.xml and MS_home/etc/deleterelatedtables.xml. Data trimming performed by running datatrim.sh affects the following tables:
- REQUEST METHOD
- TRAP_HISTORY
- TRAP_THREAD_DUMP
- TRAP_METHOD_DETAIL
- TRAP_STACK_TRACE
- MEMORY_DATA
- GC_DATA
- IMSEVENTS
- VOLUMESTAT
- PORTALSTATS
- PORTALOVERVIEW
- PMISTATS
- SERVERSTATS
- PROBLEM_CENTER
- METHOD_PROFILE_DATA
- PMIJMXENGINESTATS
In the next few sections, the recommended steps to follow when trimming data by using the datatrim.sh script will be provided. In addition, a recommended set of best practices will be presented.
- Editing the deleterelatedtables.xml file
- Editing the deletesingletable.xml file
- Activation
- Verification
- Best Practices
Parent topic:
Data trimming utilities