To unmark a sequence
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setrepseq command to confirm that the sequence is marked in the primary database:
pdb_setrepseq pdb_seq
where pdb_seq is the name of the sequence that you want to unmark.
Consider the following:
If the pdb_setrepseq command returns information that the specified sequence is marked, continue this procedure to unmark the sequence.
If the pdb_setrepseq command does not return information that the specified sequence is marked, you do not need to continue this procedure.
Use the pdb_setrepseq command to disable replication of the sequence:
pdb_setrepseq pdb_seq, disable
where pdb_proc is the name of the sequence that you want to unmark.
Use the pdb_setrepseq command to remove the replication marking from the sequence:
pdb_setrepseq pdb_seq, unmark
where pdb_seq is the name of the sequence that you want to unmark.
If you need to force the unmark, you can use the following command:
pdb_setrepseq pdb_seq, unmark, force
Use the pdb_setrepseq command to confirm that the sequence is no longer marked for replication:
pdb_setrepseq pdb_seq
where pdb_seq is the name of the sequence in the primary database that you unmarked.
