ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Stop DB triggers from firing without DISABLING/REMOVING them

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stop DB triggers from firing without DISABLING/REMOVING them

    Hi,
    We have a need where we want both the live prod and the HA box which gets data via MIMIX from live prod, to be up with the transaction jobs running at the same time.
    This is to ensure high availability to swap to the other box in case of issues.

    Since the transactional never ending jobs would be running and waiting for data in HA, we cannot change the DB files to disable/remove the triggers.
    However we need to stop them from being invoked(triggered) still. There are dataarea based switches within the triggers already that just quits triggering actions, but we need to save CPU by not even doing that evaluation or invoking the trigger program.

    Thanks,.
Working...
X