JournalArchive Table Item Counts

[Elio_C]

Hi,

I'm planning an upgrade and am looking for some explanation on the JournalArchive table. Running the below on each of the 3 Stores:

select COUNT(*) "STR01 JournalArchive Count" from JournalArchive
select COUNT(*) "STR01 JournalArchive where BackupComplete=1" from JournalArchive where BackupComplete=1
select COUNT(*) "STR01 JournalArchive where IndexCommited=1" from JournalArchive where IndexCommited=1
select COUNT(*) "STR01 WatchFile Count" from WatchFile

returns the below:

Why are these items here and should they be getting cleared down? As I understand it (documented in http://www.symantec.com/docs/TECH66202) these items should be being purged.

This is a 9.0.5 system.

Any help greatly appreciated.

[Rob_Wilcox1 · Accepted solution]

They're used to support Vault Cache.

http://www.symantec.com/business/support/index?page=content&id=TECH67576

[Elio_C]

Thanks, that explains that then!

A follow up question, so this is the last 32 days of Vault Cache changes?
Ordering the table by RecordCreationDate shows items from 2012, is this expected?
I'd expect to see records from the last 32 days, unless there have been PST imports/new mailboxes enabled. Could that explain it?