Remove old data from ESP_APPLICATION in DE (ESP dSeries) with MS-SQL DB

Products

• DSERIES- SERVER
• CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

The ESP_APPLICATION table contains data of all the application generations that have been ever ran by CA Workload Automation DE.  The following SQL statement does not work on MS-SQL:

DELETE from ESP_APPLICATION where END_DATE_TIME < TO_DATE('2010-09-01','YYYY-MM-DD') and STATE like 'COMPLETE';

 

Note: In 12.1 and above use Movehistorydata command to clear data. 

 

Environment

Release: 12.0
Component: Workload Automation DE

Resolution

To clear the ESP_APPLICATION table on MS-SQL database, the user can use the following query:

DELETE from ESP_APPLICATION where END_DATE_TIME < '2010/09/01' and STATE like 'COMPLETE';

 

Note : Before issuing the above command, please backup your database. The dSeries server must not be running. It is also recommended to move all the older entries to some other location for any future consultation or auditing requirements.