APMInsight Data Cleanup Standalone script - Usage

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:

  1. Open Command prompt or Terminal and Navigate to <APPMANAGER_HOME>/bin
  2. Execute the below mentioned command:
Windows       
APMInsightDataCleanup.bat <OPTIONS>
Linux       
sh 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 olderpartitionsAPMInsightDataCleanup.bat olderpartitions
oldertraces
It used to delete only the trace files older than retention period.
sh APMInsightDataCleanup.sh oldertracesAPMInsightDataCleanup.bat oldertraces
full
It will delete all partition tables, trace files ( current and older than retention period. )
sh APMInsightDataCleanup.sh fullAPMInsightDataCleanup.bat full

Sample Execution :

Windows:
     
Linux:

           

                  New to ADSelfService Plus?

                    • Related Articles

                    • Troubleshoot - Duplicate APMInsight Monitors

                      Introduction Duplicate monitors might be created in APMInsight due to various reasons. This article will help you identify and resolve the issue of duplicate monitors. The common causes include: - Changes in monitor configuration. (apminsight.conf ...
                    • 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   ...
                    • 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 ...