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

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.