Configuring replication in the standby database

The dsi_replication configuration parameter specifies whether or not transactions applied by the DSI are marked in the transaction log as being replicated. It must be set to “on” for the active replicate database. By default, it is set to “off” for the standby database and set to “on” for all other databases.

When dsi_replication is set to “off,” the DSI executes set replication off in the database, preventing Adaptive Server from adding replication information to log records for transactions that the DSI executes. Since these transactions are executed by the maintenance user and, therefore, are not replicated further (except if there is a standby database), setting this parameter to “off” where appropriate writes less information into the transaction log.

Use admin who, dsi to see how this parameter is set for a connection.