How to determine if an index location is open/closed using the SQL EnterpriseVaultDirectory database.

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



The EnterpriseVaultDirectory database IndexRootPathEntry table and view_IndexRootPath view contains information about each index location within the Directory. This includes a column named IndexRootPathStatus. The IndexRootPathStatus shows the current state of each Index Volume associated within the Directory. Possible values of this entry are:

  • 0 – Indicates that the location is open. Indexing can add data to this location.
  • 1 – Indicates that the location is closed. Indexing cannot add data to this location. If there are new items for existing indexes, Indexing uses a different location.


Example: 
Run the following SQL Query to identify all of the currently open index locations:

USE EnterpriseVaultDirectory
SELECT *
FROM View_IndexRootPath
WHERE IndexRootPathStatus = 0



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


Terms of use for this information are found in Legal Notices