Description

When using an EMC Centera Storage Device with Enterprise Vault (EV), items sent to the device are referenced back with a C-Clip value.  A C-Clip value is a Content Address that the Centera system returns to the client. This value points to the Clip Descriptor File on the Centera which, in turn, contains the Content Address to retrieve the C-Clip file. Generally, this 'Clip' is a reference for Enterprise Vault for where the stored data is located on EMC Centera for retrievals.

Depending on if Collections for the Centera Vault Store Partition is utilized, a C-Clip reference may be stored in different locations within the Vault Store Database in SQL:

Collections enabled:

SELECT *
FROM Collection
WHERE RelativeFileName = ''

    To determine what Saveset Transactions are associated to a C-Clip:

SELECT C.CollectionIdentity, C.RelativeFileName, S.IdTransaction, S.ArchivedDate, S.ItemSize
FROM Collection C, Saveset S
WHERE C.CollectionIdentity = S.CollectionIdentity
AND C.RelativeFileName = ''

Notes:
a. When collections are enabled, there will be 100 savesets (archived items) associated with a single C-Clip
b. Storing to Centera does not utilize a Vault Store Group (Fingerprint) Database and the saveset are not stored into separate files prior to being sent to Centera.

Collections not enabled:

SELECT *
FROM SavesetStore
WHERE StoreIdentifier = ''

    To determine what Saveset Transaction is associated with a C-Clip:

SELECT *
FROM Saveset
WHERE SavesetIdentity
IN (SELECT SavesetIdentity
FROM SavesetStore
WHERE StoreIdentifier = '
Note: When Collection are not enabled, a single saveset is given a single C-Clip value.