filter_maint_userid

Determines whether operations applied by the maintenance user are ignored.

Default

true

Values

true – enables the Log Reader to ignore maintenance user operations.

false – disables the Log Reader filter to allow replicating maintenance user operations.

Comments

  • The filter_maint_userid configuration parameter is provided to support bidirectional replication, in which the primary database also serves as a replicate database that has transactions applied to it by a Replication Server maintenance user.

  • If the value of the filter_maint_userid parameter is true, database operations applied by the maintenance user are not replicated. The Log Reader component filters out (ignores) operations applied by the maintenance user when it reads the transaction log.

  • If the value of the filter_maint_userid parameter is false, database operations applied by the maintenance user are replicated. The Log Reader component replicates all operations on marked objects, regardless of the user that applied the operation.

  • The maintenance user login is specified when the database connection for the primary database is created in Replication Server.