RE: Remove (temporaritly) Triggers

Would that not disable all the triggers on the system? I'm only after the
ones for the security collection. The rest of them need to stay in place.


So the root question is do we know the names of the tables that are used
with the QSYS2.AUTHORITY_COLLECTION view? Maybe a naïve question, but an
honest one at least. I've not delved into those tables much yet.


--
Jim Oberholtzer
Agile Technology Architects

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Monday, September 25, 2017 2:06 PM
To: Midrange Systems Technical Discussion
Subject: Re: Remove (temporaritly) Triggers

I believe the HA products do this by disabling the triggers. Such as
CHGPFTRG STATE(*DISABLED)

Production:

Trigger Description
Trigger name . . . . . . . . . . . . . . . : TRG QSYS_TRIG_ERPLXF_
____IIM________000002
Trigger library . . . . . . . . . . . . . : ERPLXF
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *INSERT
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Program Name . . . . . . . . . . . . . . : PGM SYS638B
Library . . . . . . . . . . . . . . . . : ERPLXPTFO


H/A:

Trigger state . . . . . . . . . . . . . . : STATE *DISABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 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





From: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 09/25/2017 02:58 PM
Subject: Remove (temporaritly) Triggers
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Folks:



I am working on a security project where we are using V7R3 and the
authority
collection capability. The goal is to analyze the data and set up object
access in a much better way.



The Customer has purchased several products from Help Systems, to bolster
their tooling, to which I have no problem at all, they are very reasonable
products, they do however present a challenge. Apparently they put
several
triggers on the database tables that QSYS2.AUTHORITY_COLLECTION uses, so
we
cannot write our own SQL against it to do any special reporting we might
wish to do that might not be included in the tooling.



How do I disable the trigger(s) temporarily? I thought CHGPFTRG would
work
but I have not been successful yet.





--

Jim Oberholtzer

Agile Technology Architects