Forum Discussion

Tobbe's avatar
Tobbe
Level 5
15 years ago

JournalArchive table

Hi.

I'm wondering if anybody could help me understand what process that actually purges the items in the journalarchive table in SQL?
I am talking about the situation where both the "Index commited", and "backup complete" columns are correctly populated with "1", and thereby also the watchfile table has been purged as part of the postprocessing if you have the vaultstore set to remove save sets after backup.

This is stated in technote 316761:

Notes:
   a. These items are removed from the JournalArchive Table and the WatchFile Table once Indexcommited and BackupComplete are both 1.


Currently, I have quite a few items in the journalarchive table that are both indexed and backed up. Whats the logic here?

Thanks in advance,
/Tobbe
  • Yea if you lower that down JournalArchive should clear down accordingly, it is a new setting in 8 afaik so that is probably why your JournalArchive is building up :)

    Hopefully I have answered that for you?

8 Replies

  • Hi, sorry for missing the details.

    This setup is running version 8.0 SP 3
  • could be that the item isn't truely secured, check the Backup tab on the properties of each of your partitions
  • Hi.
    I've checked the more recent partitions and the few items that are listed there as unsecured is due to regular archiving/backup cycles. I'm curious though - What could make an item to be something else than "truely secured" if it has been both indexed and backed up?

    Thanks,
    /Tobbe
  • Hi again.

    I think you're on to something here.
    It is more than a million items but it seems as if the oldest ones are just over a month.

    Your very specific question about 32 days lead me to the setting for transaction history. I guess that is the reason for keeping these items?
  • Yea if you lower that down JournalArchive should clear down accordingly, it is a new setting in 8 afaik so that is probably why your JournalArchive is building up :)

    Hopefully I have answered that for you?
  • Yepp, that helped me to understand the situation. Thanks!

    /Tobbe