JournalArchive table
Updated: 21 May 2010 | 8 comments
This issue has been solved. See solution.
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
Discussion Filed Under:
Comments
What version of EV are you
What version of EV are you using?
Hi, sorry for missing the
Hi, sorry for missing the details.
This setup is running version 8.0 SP 3
could be that the item isn't
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
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
Are these items 32 days old
Are these items 32 days old and younger only?
Hi again. I think you're on
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
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
Yepp, that helped me to understand the situation. Thanks!
/Tobbe
Would you like to reply?
Login or Register to post your comment.