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.htmKind 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.
------------------------------
Original Message:
Sent: 11-08-2019 05:46 AM
From: O'Mullane
Subject: Is our Database Purge Process working properly?
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.