Re: In a HA environment: Do triggers fire when a database record gets updated?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

My understand is that the answer is yes, triggers are a function of teh DB
and the DB doesn't care who initiated the change.  AFAIK every HA vendor
recommends that triggers be disabled on the destination system and that
instead the HA software should be replicating the changes made to dependent
files by triggers on the source system.  In other words, you should be
using HA for all files and not trying to make use of triggers on the
destination.

IIRC, IBM added the *ENABLE/*DISABLE functionality to CHGPFTRG mainly per
the request of HA shops/vendors.

Charles


On Mon, Apr 15, 2013 at 1:51 PM, David Gibbs <david@xxxxxxxxxxxx> wrote:

> Folks:
>
> I've got a customer who has a HA environment (I'm not sure what HA system
> though).
>
> They have our product replicated on the slave system, but some components
> aren't working correctly.
>
> Do database triggers fire, on the slave system, when a record update is
> replicated from the host?  Is this dependent on the HA system?
>
> Thanks!
>
> david
>
> --
> IBM i on Power Systems - For when you can't afford to be out of business
>
> I'm riding a metric century (100 km / 62 miles) in the 2013 Chicago Area
> Tour de Cure to raise money for diabetes research and education!  Sponsor
> me by visiting http://archive.ridewithdavid.com.  Thanks!
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.