Forum Discussion

m_mueller's avatar
m_mueller
Level 2
6 years ago

Delete large Journal Archive

Hello, I got a question to delete an journal archive with about 5.000.000 Items. Cause: We have to retire an old centera. what happend so far: We migrated our data two years ago from a centera t...
  • GertjanA's avatar
    GertjanA
    6 years ago

    Hi Michael,

    To remove the archive without actually deleting it is an action which is not supported. It would mean hacking SQL, possibly causing all kind of issues. If you really want this, you should contact support, see what they can offer.

    As for the deletes on the Centera, one thing to take in account is a possible retention clash. Can the items be deleted? Or are you seeing these few items per hour due to Compliance Mode?

    Deleting an archive puts pressure on SQL, Indexes and Storage. Is your SQL keeping up?

    I could not find info on deleting an archive with Centera as storage, only expiry.

    See This and Also this article.

GertjanA's avatar
GertjanA
Moderator
6 years ago

Hi Michael,

To remove the archive without actually deleting it is an action which is not supported. It would mean hacking SQL, possibly causing all kind of issues. If you really want this, you should contact support, see what they can offer.

As for the deletes on the Centera, one thing to take in account is a possible retention clash. Can the items be deleted? Or are you seeing these few items per hour due to Compliance Mode?

Deleting an archive puts pressure on SQL, Indexes and Storage. Is your SQL keeping up?

I could not find info on deleting an archive with Centera as storage, only expiry.

See This and Also this article.

  • m_mueller's avatar
    m_mueller
    Level 2
    6 years ago

    Hello,

    you point me to the right direction.
    Expiry is the solution. This is a little bit risky because we never used this.
    But you could run a report mode before to see what will happened.
    This is much faster compare with the normal deletion.
    And it’s also a good idea to increase the threads for expiry.
    The C clips are removed about 8 times faster like before.
    This is not light speed but its ok for my environment.
    Thank you

    Michael