Poll - Ensemble Users - Journal Settings - Freeze On Error - Y or N

Question

Question

Barry Veach · Jun 2, 2018

#Journaling #Mirroring #System Administration #Ensemble

In System Administration | Configuration | System Configuration | Journal Settings there is a check box for Freeze on error.

From reading the documentation, it sounds like the choice to freeze on error is one of system availability vs system integrity.

Curious to know whether Ensemble users choose to freeze on error or not.

If you have a best practice recommendation based upon your experience or knowledge, that would be helpful information too.

Discussion (3)2

Log in or sign up to continue

Jeffrey Drumm · Jun 2, 2018

The setting is overridden on a primary mirror member such that all global updates are frozen on a journal write error anyway, so the setting really doesn't matter unless you're operating in a non-mirrored configuration. I've yet to run across a healthcare implementation of Ensemble that wasn't mirrored, but I suppose they exist somewhere. For those cases, I would enable Freeze on Error. Better late delivery than data loss.

0 0

Alexander Riemer · Jun 5, 2018

We're running several Caché instances and had issues with this setting set to "No"!

As we heavily rely on transactions, which need a working journal, we decided to set this switch to "Yes" on all systems and never had problems since then.

0 0

score 0 · Answer 1 · 2018-06-04T12:47:38-04:00

Right, mirroring already takes care of the 'system availability', so this setting is forced to be turned on to also protect 'system integrity' (not to mention so mirroring can more easily detect failures).

I would say though that whether you need this turned on in a non-mirrored setup entirely depends on your application. You may have a major preference towards system availability over system integrity, though I'd say most setups that care enough about the data to journal it would likely want to have this Freeze on error turned on.