How to clean the watchfile table?
Hello all,
We are fighting with an issue that prevents us from upgrading to EV9 and EV10 consequently.
We took over support for an EV8 setup that was configured with single Centera system without replication and therefore it has the watchfile table with 54M items (~24M items for the Journal Vault Store DB and ~30M items for the Mailbox Vault Store DB).
As it was already learned, these tables should be cleaned up before the upgrade otherwise the upgrade could take days or even weeks with EV locked out from users. So, the technote http://www.symantec.com/docs/TECH68494 was implemented.
It works fine for the Journaling (it's slow, though) process - mails are journaled and table processing is going on in the same time.
Unfortunately, it doesn't work well for the Mailbox database. Queue A1 is piling up with items and table processing is going on, archived mails are accessible but new mails can not be archived (new requests correctly are being correctly placed to A2 queue, but never processed because A1 queue never drains).
So, the questions are:
1. Is there any way to clean up the table in one shot using some SQL query? We definitely don't need to go through each and every item, because neither of those will have a replica.
2. If option 1 is not available, is there any way to keep the cleanup process running, but at lower priority comparing to mailbox archiving and keep the EV system fully available to users?
- Check your connect inbox, just sent you a message