RE: Audit Journal Entry for Trigger Enable/Disable

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.


On 5/13/2019 9:36 AM, Rob Berendt wrote:

When trying to search by description, instead of code, this may be
more helpful
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzaki/rzakijo
urnalfinderall2.htm searching that for trigger gets a lot of hits but
I'd start with these three: D-TC, D-TD, D-TG.
I'm guessing D-TG.
Mimix does disable triggers. Normally on the target system they are all disabled. Makes perfect sense to me. Let's say you have a trigger on IIM. This trigger sends an email when the balance gets too low and logs a transaction to IIMHIST. Now, Mimix replicates IIMHIST also. Do you want the replication to double book the IIMHIST replication AND the trigger to fire on your HA machine to log another transaction to IIMHIST? No. Do you want two emails? No.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Rich Loeber
Sent: Monday, May 13, 2019 10:25 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Audit Journal Entry for Trigger Enable/Disable

Joe,

Here's a link from the IBM Knowledge Center:

[1]https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzaru/rzar
ufinder.htm

Rich Loeber - @richloeber
Kisco Information Systems
[2]http://www.kisco.com


----------------------------------------------------------------------
----

On 5/13/2019 10:00 AM, Joe Pluta wrote:

Alternately, does anyone know of a single PDF that contains all the
audit journal entry definitions? I could search that...

On 5/13/2019 8:40 AM, Joe Pluta wrote:

Does anyone know if there is an audit log entry that indicates when a
trigger is enabled or disabled?  We have some triggers on the
development machine that occasionally get re-enabled by Not Me (as in,
"Who enabled the trigger?" "Not me!").

MIMIX is one suspect, but the last time it happened was about four
weeks ago, so it seems pretty random even for MIMIX.

References

Visible links
1. https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzaru/rzarufinder.htm
2. http://www.kisco.com/
--
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

--
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