SAP ASE Support for Replication by Column Value

SAP ASE extends Multi-Path Replication™ by including a new distribution model that provides support for distributing replicated rows based on the data values in one or more columns in a single table.

You must enable multiple scanners before you select distribution by column filter.

Filter Conditions

The SAP ASE RepAgent uses the replication filter to identify only the table rows that meet conditions that you specify in the filter from the specified table.

The filter conditions are:

SAP ASE System Table Storage for Replication Filters

A bound replication filter object is stored in these SAP ASE system tables:
  • sysattributes
  • sysobjects
  • syscolumns
  • sysprocedures
  • syscomments
  • sysdepends

The replication filter is represented as RF for the value of sysobjects table column type and the object_type column of the sysattributes table.

Creating and Dropping Replication Filter Table Objects

You can create a replication filters table object on the primary SAP ASE database using the create replication filter command. See Additional Distribution Mode for Multi-Path Replication in the Replication Server New Features Guide for a list of restrictions that apply when creating a replication filter.

You can remove a replication filter using the drop replication filter command. RepAgent automatically drops filters that you create on a table if you drop the table that has the filters. You cannot drop a replication filter that is bound to a path while RepAgent is running in filter mode. If you bind a filter to a replication path, Replication Server replicates only the data that satisfies the filter conditions across the path.

Displaying Filter Replication Information and Dependencies

Use procedures sp_depends, sp_columns, sp_help, and sp_helptext to show filter replication information and dependencies.

Configure Alternate Replication Paths Between a Primary Database and Replication Server.

The sp_replication_path procedure has been updated to support binding, unbinding, and listing of filters.

For more information, see:

Additional Distribution Mode for Multi-Path Replication in the Replication Server New Features Guide.

To configure replication filters, see Replication Server Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication > Parallel Transaction Streams > Distribution by Column Value.

See create replication filter, drop replication filter, and sp_replication_path in the Replication Server Reference Manual.