Automic Workload Automation

 View Only
  • 1.  Is our Database Purge Process working properly?

    Posted Nov 08, 2019 05:47 AM
      |   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   16 KB 1 version


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

    Posted Nov 08, 2019 08:33 AM
    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 Nov 08, 2019 09:08 AM
      |   view attached
    Apologies, I meant to also attach the unload. attached now.

    Attachment(s)

    txt
    153523790.REP.txt   388 KB 1 version