Clean Up APM DB

book

Article ID: 221884

calendar_today

Updated On:

Products

CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

We need to clean up the APM Database to see Experience Cards

 

Here is output (APMMGR objects >= 100MB)

 

SEGMENT_NAME            SEGMENT_TYPE     SIZE_MB

 

APPMAP_ATTRIBS          TABLE                107

TS_AUDIT_RECORD_PROPS   TABLE                136

ACA_AUDIT               TABLE                244

APM_GEOLOCATION         TABLE                269

APPMAP_VERTICES         TABLE                294

APPMAP_ATTRIBS1_IDX     INDEX                428

 

Environment

Release : 10.7.0

Component :

Resolution

Here are the suggestions to clean up data in Oracle.

1) DELETE FROM APM_GEOLOCATION or TRUNCATE TABLE APM_GEOLOCATION. Unless you need Geolocation in CEM, would clear  out all rows

2) DELETE FROM ACA_AUDIT or TRUNCATE TABLE ACA_AUDIT  

3) alter table appmap_edges enable row movement;
alter table appmap_vertices enable row movement;
alter table appmap_attribs enable row movement;


alter table appmap_edges shrink space compact;
alter table appmap_vertices shrink space compact;
alter table appmap_attribs shrink space compact;

4)   The APM CE Audit Trail is stored inside the APM database in these table: ts_audit_records  and ts_audit_record_props. 
If you don't need audit records , can clear these two or do by creation date date  

5) CEM Database Cleanup -- https://community.broadcom.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=970f60d7-1ca3-411e-8848-d375608e431c&forceDialog=0 General CEM database cleanup

6) Execute cleanup that will delete topological history before some date (14 days before current date/time). For example "2017-09-15 00:00:00":
jre/bin/java -jar sqlTools6.jar cleanup "2017-09-15 00:00:00"