Enabling and disabling replication for stored procedures

If you need to temporarily suspend replication of a stored procedure, you can 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, you can use the pdb_setrepproc command to enable replication.

NoteProcedure replication is not implemented for DB2 Universal Database.

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.

Marking a stored procedure for replication is separate from enabling replication for the stored procedure. See “Marking and unmarking stored procedures” for more information on marking a stored procedure for replication.