Remove CA 7 data from iDash

Products

• iDash Workload Automation

Issue/Introduction

How can I remove only the old CA 7 data from the iDash database - job run data, SLA data etc.  Is there any SQL to perform this task?

Environment

Release : 12.1.02

Resolution

Here are some queries to delete the information from the DB. For the queries that reference instanceName, you will need to run the query for each CA 7 instance you have defined, replacing instanceName with the actual instance name they defined.

delete from idash_average_runtime where instance = 'instanceName';

delete from idash_doc where type like '%joblink' and name like '%instanceName%';

delete from idash_config where type = 'sla' and id like '%instanceName';

delete from idash_config where type = 'ca7instance';

delete from idash_config where type = 'ca7avgtime';

delete from idash_config where type = 'ca7lasteventid';

delete from idash_config where type = 'ca7.run.report';

delete from idash_hist_jfm_console_message;

delete from idash_jfm_console_message;

delete from idash_hist_job_run_ca7;

delete from idash_job_run_ca7;

delete from idash_sla_problematic_jobs where instance = 'instanceName';

delete from idash_sla_run where sla_name like '%instanceName';