APMInsight Data Cleanup Standalone script - Usage
The APMInsight Data clean up standalone script can be used to clean up the data tables for below :
| Data / Table | Description |
Partition tables | These data tables are used to store the performance metric raw data for APM Insight Monitors for every minute. |
| Stray tables | These data tables are not in use currently. They might be left stray, with no lookup entries. ( Left stray from upgrades to builds before 15280 ). |
Retention period | This specifies the APM Insight Raw Data Retention Period and can be found in  Admin -> Performance Polling -> APM Insight -> Raw Data Retention Period |
Traces | The traces found in APM Insight -> Traces Tab are stored in the custom path specified at <APM_Home>/working/apminsight/conf/apminsight.properties -> apminsight.tracesdir (or) <APM_Home>/working/apminsight/traces |
Current Partition Tables | These data tables are used to store the current week's raw performance data. |
Older Partition Tables | These data tables have performance metric raw data older than the retention period. |
Steps to Execute Script:
- Open Command prompt or Terminal and Navigate to <APPMANAGER_HOME>/bin
- Execute the below mentioned command:
WindowsAPMInsightDataCleanup.bat <OPTIONS>Linuxsh APMInsightDataCleanup.sh <OPTIONS>
| Options | Description | Usage | |
| olderdata | It does clean up of stray tables , partition tables and trace files - which are older than retention period. | sh APMInsightDataCleanup.sh olderdata | APMInsightDataCleanup.bat olderdata |
| stray | It is used to delete only the stray tables (which are no longer used.) | sh APMInsightDataCleanup.sh stray | APMInsightDataCleanup.bat stray |
| olderpartitions | It is used to delete only the partition tables which are older than retention period. | sh APMInsightDataCleanup.sh olderpartitions | APMInsightDataCleanup.bat olderpartitions |
| oldertraces | It used to delete only the trace files older than retention period. | sh APMInsightDataCleanup.sh oldertraces | APMInsightDataCleanup.bat oldertraces |
| full | It will delete all partition tables, trace files ( current and older than retention period. ) | sh APMInsightDataCleanup.sh full | APMInsightDataCleanup.bat full |
Sample Execution :
Windows:
Linux:
New to ADSelfService Plus?
Related Articles
APM Insight monitor is UP, but monitor page doesn't show any data
Possible Causes The APM Insight monitor status corresponds to the respective agent folder pointed Java Application status i.e., as long as the Application server is running, the monitor status will be UP. 1. No Transactions Recorded: It is possible ...Script/Custom Monitors - Alarms configured for Table rows were missing
In the Applications manager , users have the ability to manage the table rows of a script or custom monitor type according to their specific requirements. This can be done by enabling the "Enable Script Row Deletion" option. For example, let's ...Memory Usage Calculation (Linux- Telnet/SSH)
Total Memory Utilization Calculation: Linux Monitoring: Telnet/SSH For memory usage calculation using 'free -m' command. Sample command output: root@root:~$ free -m total used free shared buff/cache ...How to execute SAP Debug script
1. Steps to execute troubleshooting script SAPDebug.bat/sh: Open command prompt/terminal with administrator privileges. Navigate to <AppManager_home>\bin\troubleshooting folder. Execute the script file SAPDebug.bat or SAPDebug.sh Usage: SAPDebug.bat ...Self monitor Applications Manager using APM Insight Java Agent
Applications Manager is built with Java, hence we can monitor it using APM Insight Java Agent to measure it's performance continuously, which can be very much useful. Setting up APM Insight Java Agent Follow the below steps to download and set up the ...