delete historical information

[Ayzar Talip]

Hello partners

Do you have a procedure to deleted information from CAWA Dseries R12 historical tables (H) without affecting the integrity of the information?

Do you have a procedure to debug CA WA Dseries 12 historical tables (H) without losing the integrity of the information?

I just need to leave the information for the last 6 months.

Is there an automatic process in the app?

Exist an automatic process to eliminated the hstorical information?

CA Workload Automation Server Id: CENTRAL_MANAGER
CA Workload Automation Server Version: 12.0.01.00
Build: 0616
Build Date: 201609280123
High Availability is Enabled. Current Server Mode: PRIMARY

Microsoft Windows Server 2012 R2 Standard
Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64) Standard Edition

Thank you
Regards

[Nitin Pande]

Hi,
You can use CLI command "deletestagingdata".  It allows you to delete data from H_ tables from DE. 
This command is available in R12.1 and later.  See this link for more details on how it clears the tables.


Nitin Pande

------------------------------
Support
Broadcom
Toronto
------------------------------

[Ayzar Talip]

Hi Nittin

if i dont have this version, its not possible the depuration?

i have CA Workload Automation Server Version: 12.0.01.00
the command does not exist

I need to open a case with the support team?

regards

[Nitin Pande]

Hi
The command is only available in 12.1 or above.  R12.0.01 will be out of support in Oct 2020.  So you should plan to upgrade your DE.
All new changes will only be made 12.2 or above.

HTH,
Nitin Pande

------------------------------
Support
Broadcom
Toronto
------------------------------

[Ayzar Talip]

Hi Nitin

Just to understand the possibilities we have
In this version CA WA Dseries 12.0.01.00, its not possible the depuration?

Regards

[SHARON SHIMANEK]

even if you plan to upgrade you probably want to delete data before the upgrade.  We run sql job to delete data from h_application

will delete anything older than 370 days old, you would need to be sure you don't have anything active that is that old.  
delete WA.H_APPLICATION where WA.H_APPLICATION.SCHEDULED_DATE_TIME < sysdate-370

this will delete specific application name that starts with QM and is older than 180 days and is in complete state
delete WA.H_APPLICATION WHERE APPL_NAME like 'QM%' and WA.H_APPLICATION.END_DATE_TIME < sysdate-180 AND STATE='COMPLETE'