The DB Reorg (using the utility) was interrupted while it was running.
As a consequence, many data in the DB was flagged with a "deleteflag" :
select count(*) from ah where ah_deleteflag = '1'
28 452 665
select count(*) from oh where oh_deleteflag = '1'
1 742
select count(*) from rh where rh_deleteflag = '1'
3 479 378
-
Release : 12.3
Component : AUTOMATION ENGINE
The DB Reorg utility allows you to reset the existing traceflags :
ucybdbun -BRESETREORG
https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Utilities/admin_AE_DB_Reorg.htm
To prevent the DB Reorg utility from running for too long, if you need to handle a large period of statistics (for example moving from 90 retention days to 30), then the best way to do so reduce the REORG period step by step :
-> Reorg on 80 days
-> Reorg on 70 days
and so on, until you reach 30 days