[AWA] How to run a Db Reorg when it has been stopped unexpectedly

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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

 

 

Cause

-

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

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