Triggers

Trigger definitions are replicated if the file, table, or view they are defined on is replicated. For Db2® Mirror, triggers fire on only the source node.

Both native and SQL triggers are fired only on the node that initiated the data change operation. If an action performed by the trigger, such as updating a second file, must be replicated, the second file must be included in replication as well.

Trigger program replication considerations

An SQL trigger cannot be created if the library containing the file object excludes program objects from replication.

To add a native trigger to a replicated file, the program for the native trigger must be included in replication.

If an SQL trigger program for a replicated file gets deleted on both nodes, it will be recreated on each node independently when it is fired on that node.