Unmarking a table

For IBM DB2 Universal Database only, Replication Agent must be in Admin state when unmarking.

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

2. Use the pdb_setreptable command to confirm that the table is marked in the primary database:

   pdb_setreptable pdb_table
   

   Here, pdb_table is the name of the table in the primary database that you want to unmark.

   If the pdb_setreptable command returns information that the specified table is marked, continue this procedure to unmark the table.

   If the pdb_setreptable command does not return information that the specified table is marked, you need not continue this procedure.

3. Use the pdb_setreptable command to disable replication from the table:

   pdb_setreptable pdb_table, disable
   

   Here, pdb_table is the name of the table in the primary database that you want to disable.

4. Use the pdb_setreptable command to remove the replication marking from the table:

   pdb_setreptable pdb_table, unmark
   

   Here, pdb_table is the name of the table in the primary database that you want to unmark.

   If you need to force the unmark, you can use the following command:

   pdb_setreptable pdb_table, unmark, force
   

5. Use the pdb_setreptable command to confirm that the table is no longer marked for replication:

   pdb_setreptable pdb_table
   

   Here, pdb_table is the name of the table in the primary database that you unmarked.