We use MIMIX and replicate to two systems, another partition on the same local PROD sever (HA), and to a remote DR server about 80 miles away. We perform nightly backups of our customer data on the HA system, ending replication to allow for an accurate and unlocked snapshot of the data. This is the only time the replication is shut down on a daily basis, and it is usually only about 10 to 15 minutes. DR replication is not affected. We do a monthly full SAVSYS on all systems, but not any at the same time so replication is not ever fully stopped. When we backup PROD we like (not always) to switch to HA to stay available for the customers.
We do a complete end of all data groups on HA when performing the daily backup. That might be overkill and the command offered by MIMIX support is probably better if you want to keep the journal entries flowing. I might even consider switching to this method. We also try to "monitor" the HA system to ensure it is not in a threshold status (i.e. all journal entries have been processed) before taking the backup, ensuring data is up to date from our nightly processing, which sometimes during high transaction rates it can get backed up for a bit on the target. These backups are used in case we need to go back to a certain day for specific information, not necessarily for a disaster recovery purpose - that is what the DR box is for.
We do not use BRMS.
MIMIX support is very good in helping to verify or confirm that what you are thinking is accurate, but since environments vary so greatly, they may be hard pressed to say what would work best for *all*.
Hope that helps.
Dave
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, March 02, 2011 4:29 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Backing up from your Mimix HA machine
I ran the following by Lakeview support:
<snip>
Suppose your source machine is GDIHQ and your target machine is GDIHQ2. I am hearing that we should forego backups on GDIHQ and we should be backing up from GDIHQ2 as to not disrupt our line of business.
Do you have any documentation on the "best practices" of doing that? Like, do I shut down Mimix enough to free the locks and allow us to perform our backups but not so far as to kill the remote journals from still getting their entries?
We want to use BRMS.
</snip>
And their reply was
<snip>
Yes, lots of installations do their backups on their HA systems. There really isn't an official "Best Practice" recommendation, but personally, I would set it up just as you describe. Specifically, you can do:
<mimix>/ENDDG DGDFN(*ALL) PRC(*DBAPY) ENDOPT(*IMMED) ENDRJLNK(*NO)
at the beginning of your backup process, then restart the MIMIX processes
with:
STRDG DGDFN(*ALL) PRC(*DBAPY)
</snip>
Sounds pretty straight forward to me. Does anyone have any comments or suggestions?
Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
NOTICE - This e-mail message is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this message, you are hereby notified that any dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please notify the sender by e-mail or telephone and delete the original and all copies of this message immediately.
www.ephratanationalbank.com<
http://www.ephratanationalbank.com>
midrange.com
