RE: Audit Journal Entry for Trigger Enable/Disable

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/rzakijournalfinderall2.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/rzarufinder.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