CA Service Management

  • Private Community
 View Only

  • 1.  DELETE TENANT DATA

    Posted Mar 01, 2021 06:09 AM
    I need to delete the data for a specific tenant however the volumes are huge, eg. act_log = 4,427,984 records alone for the specific tenant.
    I have a list of all the tables using the specific tenant.  Can we use SQL scripts to delete these?
    What other options are there except the pdm_tenant_delete utility?
    Any suggestions?

    Version 17.3 Cum#1


  • 2.  RE: DELETE TENANT DATA

    Posted Mar 01, 2021 08:12 AM
    Better to do this activity via archive n purge rule



    Original Message


  • 3.  RE: DELETE TENANT DATA

    Posted Mar 01, 2021 08:29 AM
    Note that ALL data must be deleted, data paritions, access types, absolutely all data relevant to the specific tenant.
    I don't think archive & purge will do that.
    Original Message