Re: Audit Journal Entry for Trigger Enable/Disable

In fact there is a simple way to disable the triggers even in a
RubeGoldberg system.

Also SyncSort has 24/7 support so I would suggest calling them or checking
the knowledge base which is very good.

On the data group definitions you'll find these two entries which may
help. Or as I said I would call SyncSort,


Disable triggers during
apply . . . . . . . . . : *YES
Process trigger entries . : *YES



Augie Palumbo
312-735-3723
702-826-2836


On Mon, May 13, 2019 at 12:08 PM Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
wrote:

Long story short, we use virtual role swap as a way to get a daily
refresh. We replicate some of our production data to an environment on
the development machine. Every morning we role swap and let developers
use that environment for testing and production debugging. Every night
we switch it back and MIMIX reverts their changes and syncs with
production.

A bit Rube Goldberg for my tastes, but it's working for now. Except for
the triggers. Some triggers access data which is not replicated to
development. So those triggers need to be removed or at least
disabled. I'm not sure if there's a way to tell MIMIX to ignore them
for this instance, but I do know how to use the brute force method of
modifying the role swap program.

On 5/13/2019 1:59 PM, Rob Berendt wrote:

I would ask Mimix about that.
First thing, we never used the virtual role swap. We just ran the

regular swap once a quarter. Did not see the point of the virtual swap.
But when we run on the backup machine we do want the triggers to fire.

Never had a problem with the triggers.


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of

Joe Pluta

Sent: Monday, May 13, 2019 2:50 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Audit Journal Entry for Trigger Enable/Disable

Yep, it was D-TG. And it was MIMIX.

And now I have to figure out how to deal with this. There are some

triggers that we simply don't want on this particular target instance. So I
may have to add cod to disable them in our virtual role swap program. Not
the end of the world, but something to consider.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com