Enabling and Disabling Replication for Stored Procedures

To temporarily suspend replication of a stored procedure, use the pdb_setrepproc command to disable replication for the marked stored procedure. When you are ready to resume replication of the marked stored procedure, use the pdb_setrepproc command to enable replication.

Note: Procedure replication is not supported for UDB.

To replicate invocations of a stored procedure in the primary database, the stored procedure must be marked for replication, and replication must be enabled for that stored procedure; no procedures are marked by default for replication.

Marking a stored procedure for replication is separate from enabling replication for the stored procedure.

Related concepts
Marking and Unmarking Stored Procedures