How to determine if an index volume has some pending additions/deletions/updates

Article:HOWTO56249  |  Created: 2011-07-27  |  Updated: 2011-07-30  |  Article URL http://www.symantec.com/docs/HOWTO56249
Article Type
How To



There are three tables in the Vault Store database that contain entries for items that have been archived.

  • JournalArchive - This table contains information about items that have been added to the archive
  • JournalDelete - This table contains information about items that have been deleted from the archive
  • JournalUpdate - This table contains information about items that have been updated in the archive

Where an entry in any of these tables has the IndexCommited column set to 0, this means that the related index volume has pending additions, deletions or updates.

For example, to find all of the index volumes that contain pending additions, use the following query:

use EnterpriseVaultDirectory
select VaultEntryId,ArchiveName,FolderName from IndexVolumeView IVV
where IVV.VaultEntryId in (select distinct AP.ArchivePointId from  EVVSVStoreThread_13..ArchivePoint AP
inner join EVVSVStoreThread_13..JournalArchive JA
on AP.ArchivePointIdentity = JA.ArchivePointIdentity
and JA.IndexCommited = 0)


Replace EVVSVStoreThread_13 with the name of the Vault Store database. 
 



Article URL http://www.symantec.com/docs/HOWTO56249


Terms of use for this information are found in Legal Notices