AI archives get created even when no one is using the db - Forum - OpenEdge RDBMS - Progress Community

AI archives get created even when no one is using the db

 Forum

AI archives get created even when no one is using the db

This question is answered

Hi,

Enabled ai archiver on a static database, set the interval to run every 2 mins. New archives get created but nobody else is using the database except me. What would be on those archives?

From rfutil list, it shows the extent status changes (busy, empty). When on one updates the db, what makes an extent busy to full?

TIA!

Verified Answer
  • At the end of each -aiarcinterval, the process repeats.  The current (busy) extent is closed, marked full, archived, marked empty, then the next (empty) extent is opened and changed from empty to busy.  This assumes there is a next empty extent to switch to.  

All Replies
  • The extent status changes are being made by the AI archiver as it closes the current extent, archives it, and opens the next extent in sequence.

  • When next iteration executes, it archives the current busy extent and marks it as full, then empty, then goes to the next extent?

  • At the end of each -aiarcinterval, the process repeats.  The current (busy) extent is closed, marked full, archived, marked empty, then the next (empty) extent is opened and changed from empty to busy.  This assumes there is a next empty extent to switch to.  

  • Ok. Thanks, so that is why new archives are created everytime even there are no changes to data.

  • Thanks!

    So that is why a new archive is created everytime even if there are no changes to the data.

  • If you configure the use of the AI archiver with an archive interval, you're saying you want a new extent every interval regardless of change activity.  

  • It would be better if the interval was skipped altogether when nothing has been written. The archived ai extents are of no value when there are no notes in them but they must be processed unnecessarily when rolling forward.