Configure Triggers in the Standby Database

You can use the alter connection command to configure a connection to fire or not fire triggers.

By default, the standby DSI thread executes a set triggers off Adaptive Server command when it logs in to a standby database. This prevents Adaptive Server from firing triggers for the replicated transactions, thereby preventing duplicate updates in the standby database.

You can alter the default behavior by using alter connection command to configure a connection to fire or not fire triggers. To do this, set the dsi_keep_triggers configuration parameter to “on” or “off.” The default dsi_keep_triggers setting for all connections except standby databases is “on.”