In a Sybase transaction replication system, the Mirror Replication Agent and Replication Server components both provide features that allow you to select the objects that you want to replicate. You need not 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 you intended to replicate is marked.
To verify that a primary database object is marked
for replication
Log in to the Mirror Replication Agent instance with the administrator login.
Use the appropriate command to determine if the object is already marked:
For a table:
pdb_setreptable pdb_table
where 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
where 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 pbd_ddl
where pdb_ddl is the name of the DDL in the primary database that you want to verify is marked for replication.
After you verify that the primary database objects are marked, see the following table:
If... |
Then... |
|---|---|
The primary database object is not marked |
Mark the object:
|
The primary database object is marked |
Check the Mirror Replication Agent status. See “Check the Mirror Replication Agent status”. |
