Automic Workload Automation

Expand all | Collapse all

Is our Database Purge Process working properly?

  • 1.  Is our Database Purge Process working properly?

    Posted 6 days ago
      |   view attached
    Hi,
    I recently opened a ticket on this but was advised by support to only contact them with problems and not advice :-).

    My DBA team tell me that our UC4 Schema (Oracle) is the biggest in the company. (see screenshot at bottom)

    Thing is that I am running a purge nightly with the following REORG settings so I'm not keeping lots of data.
    We don't have a massive number of Jobs. We are running approx 50k executions per day.

    I have also attached my latest REORG Log.

    Can anyone see anything obvious that I'm missing here?




    John.

    Attachment(s)

    txt
    153525908.REP.txt   16K 1 version


  • 2.  RE: Is our Database Purge Process working properly?

    Posted 6 days ago
    Hi John,

    I just checked the log and noticed only the DB Reorg utility. This utility only marks data records with a deletion flag in accordance with the settings that have been specified.

    Afterwards you have to run the utility DB Unload to remove the marked data records from the database. This data is then deleted throughout the AE system and in all clients.

    You can find an example workflow here: https://docs.automic.com/documentation/webhelp/english/AWA/12.1/DOCU/12.1/AWA%20Guides/help.htm#AE_AWA_Source/Script/ucabnf.htm

    Kind regards,
    Tim

    ------------------------------
    Automation Evangelist
    Fiducia & GAD IT AG
    ---
    Mitglied des deutschsprachigen Automic-Anwendervereins FOKUS e.V.
    Member of the German speaking Automic user association FOKUS e.V.
    ------------------------------



  • 3.  RE: Is our Database Purge Process working properly?

    Posted 6 days ago
      |   view attached
    Apologies, I meant to also attach the unload. attached now.

    Attachment(s)

    txt
    153523790.REP.txt   388K 1 version