ESP dSeries Workload Automation

Expand all | Collapse all

delete historical information

  • 1.  delete historical information

    Posted 07-10-2020 05:22 PM

    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



  • 2.  RE: delete historical information

    Posted 07-13-2020 08:42 AM
    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
    ------------------------------



  • 3.  RE: delete historical information

    Posted 07-15-2020 12:50 PM
    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


  • 4.  RE: delete historical information

    Posted 07-15-2020 01:29 PM
    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
    ------------------------------



  • 5.  RE: delete historical information

    Posted 07-16-2020 10:41 AM
    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


  • 6.  RE: delete historical information

    Posted 07-16-2020 10:52 AM
    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'