Function Replication Enhancements

In Replication Server 15.1, you can create a function replication definition that has a different name than the function name.

Replication Server enforces different primary and replicate function names for the request function replication definition. The maint_user runs the transaction at the replicate database if the function is replicated through applied function replication definition. The origin_user runs the transaction if the function is replicated through request function replication definition at the replicate database.

These enhancements let you:

Replicate multiple functions with the same name from different databases.
Have multiple replication definitions for one primary function and each specifies a different replicate function for a different replicate site.

To manage function replication definition, use:

create applied function replication definition
create request function replication definition
alter applied function replication definition
alter request function replication definition

Mixed-Version Support

This enhancement supports mixed-version environments. However, function replication definitions that have different primary function name and replication definition name are not replicated to Replication Servers earlier than 15.1.

Warning! If your system has an earlier version of a request function replication definition, drop the earlier-version definition before creating a 15.1 replication definition for the same primary function.

Warm Standby and Multisite Availability (MSA) Support

In a warm standby or MSA environment, there is only one parameter list for all the function replication definitions of the same primary function. If you alter one function replication definition to add a parameter, the new parameter is added to all the function replication definitions created for this function.

See “Replication Server Commands” in the Replication Server Reference Manual for detailed information about these commands.

Limitations

Enhanced function replication has these limitations:

All the function replication definitions created for the same function must have the same parameter list with the same name and datatype.
If you created a function replication definition with differing primary function name and replication definition name in version 15.1, any earlier version of the request function replication definition for the same primary function is disabled.
You cannot have both applied function replication definitions and request function replications for a primary function. The function replication definition created by using create function replication definition command is considered an applied function at the function primary site.
For each applied and request function replication definition, you must create a corresponding subscription to replicate a function.