DB Maintenance: Dependency of AE DB to ARA DB Reorganization?

Stephan SchillerStephan Schiller Koblenz, GermanyPosts: 9 Explorer ✭✭
Hello everyone,

is there any dependency of the reorganization of the AutomationEngine DB (Archive, Reorg and Unload Utilities) to the reorganization of the ARA DB (DB-Cleanup-Tool)?

Should they match each other?

For example: Reorg of the AE DB is set with "older than 30 days" and "keep last 10". Should the ARA DB-Cleanup-Tool be set with the same parameters?

Greetings

Stephan Schiller

Answers

  • Vlad NavazhylauVlad Navazhylau Posts: 88 Journeyman ✭✭✭
    We've done AE DB reorg couple times without doing any ARA DB Cleanup. 

    ARA DB growth rate is not as significant as AE DB growth.


  • Stephan SchillerStephan Schiller Koblenz, GermanyPosts: 9 Explorer ✭✭
    Ok. So you reorganize the AE DB periodically (every day, every week?) and the reorganization of the ARA DB only if necessary?

    In the AWI in "Release Automation" you´ve got an execution list for every application. From every execution you can go to the monitor of the workflow. I think the relation between the execution list in ARA and the statistics/reports of the AE will not work, in case the AE DB is reorganized already and the ARA DB isn´t. Correct?
  • Tran-Hoang HauTran-Hoang Hau Team Automic Posts: 163 Specialist ✭✭✭✭
    Ok. So you reorganize the AE DB periodically (every day, every week?) and the reorganization of the ARA DB only if necessary?

    In the AWI in "Release Automation" you´ve got an execution list for every application. From every execution you can go to the monitor of the workflow. I think the relation between the execution list in ARA and the statistics/reports of the AE will not work, in case the AE DB is reorganized already and the ARA DB isn´t. Correct?
    That 's correct, since in ARA when you check the execution if we run the DB maintenance in AE (Archive, Reorg, Unload) then there might be a change that historical record (workflow re in AE's DB getting removed. 
    However in when we perform the AE maintenance we can set how long to keep the historical records.
    I can see many of our customer keep it from 1-3 months

Sign In or Register to comment.