Verify primary database objects marked for replication

In a Sybase transaction replication system, both the Replication Agent and Replication Server components provide features that allow you to select the objects that you want to replicate. You do not need to replicate all objects or all data-changing operations in the primary database.

If a primary database object (such as a table or stored procedure) is not replicating, verify the object that you intended to replicate is marked.

1. Log in to the Replication Agent instance with the administrator login.

2. Use the appropriate command to determine if the object is already marked:

   • For a table:

     pdb_setreptable pdb_table
     

     Here, pdb_table is the name of the table that you want to verify is marked for replication.

   • For a LOB column:

     pdb_setrepcol pdb_table, pdb_col
     

     where:

     • pdb_table is the name of the marked table that contains the LOB column.

     • pdb_col is the name of the LOB column.

   • For a stored procedure:

     pdb_setrepproc pdb_proc
     

     Here, pdb_proc is the name of the stored procedure in the primary database that you want to verify is marked for replication.

   • For DDL:

     pdb_setrepddl
     

   • For sequences:

     pdb_setrepseq pdb_seq
     

     Here, pdb_seq is the name of the sequence you want to verify is marked for replication.