Forum Discussion

Elio_C's avatar
Elio_C
Level 6
10 years ago

JournalArchive Table Item Counts

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:

JournalArchive.jpg

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.

Enterprise Vault
Information Governance
Tip-How to
Troubleshooting
Windows Server (2003-2008)
  • Rob_Wilcox1's avatar
    Rob_Wilcox1
    10 years ago

    They're used to support Vault Cache.

     

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

     

2 Replies

Sort By
  • Rob_Wilcox1's avatar
    Rob_Wilcox1
    Level 6
    10 years ago

    They're used to support Vault Cache.

     

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

     

  • Elio_C's avatar
    Elio_C
    Level 6
    10 years ago

    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?