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'
Original Message:
Sent: 07-16-2020 10:40 AM
From: Ayzar Talip
Subject: delete historical information
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
Original Message:
Sent: 07-15-2020 01:29 PM
From: Nitin Pande
Subject: delete historical information
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
Original Message:
Sent: 07-15-2020 12:49 PM
From: Ayzar Talip
Subject: delete historical information
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
Original Message:
Sent: 07-13-2020 08:41 AM
From: Nitin Pande
Subject: delete historical information
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
Original Message:
Sent: 07-10-2020 05:21 PM
From: Ayzar Talip
Subject: delete historical information
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