ESP dSeries Workload Automation

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Can I delete OLDER_THAN_1MONTH DATA without moving it to the History Table?

  • 1.  Can I delete OLDER_THAN_1MONTH DATA without moving it to the History Table?

    Posted May 28, 2020 03:25 AM
    Old data can be moved to the History Table using HOUSEKEEPING_UTILITY (MOVE_HISTORY_DATA.OLDER_THAN_1MONTH).

    Can I delete OLDER_THAN_1MONTH DATA without moving it to the History Table?


  • 2.  RE: Can I delete OLDER_THAN_1MONTH DATA without moving it to the History Table?
    Best Answer

    Broadcom Employee
    Posted May 29, 2020 01:56 AM
    Hi,

    You can move to staging data and using deletestagingdata cli command to delete it from there. There is no cli command to delete it from the ESP_* history tables directly.
    You may want to use the sql query to do so. 
    Can you please let me know if there is any problem that you are facing because of which you want to remove directly.

    Ravi Kiran
    Original Message