Unmarking a stored procedure  Enabling replication for stored procedures

Chapter 3: Administering Sybase Replication Agent

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 supported for DB2 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.

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.





Copyright © 2005. Sybase Inc. All rights reserved. Enabling replication for stored procedures

View this book as PDF