Use the following procedure to clean up and remove the replication test environment that you created in the previous sections.
To clean up and remove the replication test environment
Log in to the Replication Agent administration port using isql (or another query processor).
Use the following command to quiesce the Replication Agent instance:
quiesce
Use the following command to remove the Replication Agent transaction log and unmark the test primary table (rax_test) in the primary database:
pdb_xlog remove, force
Log in to the replicate Replication Server and execute the following scripts:
$SYBASE/RAX-15_1/scripts/sybase/rs_drop_test_db_sub.sql (to drop the test subscription)
Edit the rs_drop_test_db_sub.sql script file so that the values for PDS.PDB in the with primary at clause match the PDS.PDB values that you used to create the connection from the primary data server and primary database. These values are initially {pds}.{pdb}. Also, change the values forRDS.RDB on the with replicate at clause match the RDS.RDB values that you used to create the connection to the replicate data server and replicate database. These values are initially set to {rds}.{rdb}.
$SYBASE/RAX-15_1/scripts/sybase/rs_drop_test_db_repdef.sql (to drop the test replication definition)
$SYBASE/RAX-15_1/scripts/sybase/ rs_drop_test_primary_connection.sql (to drop the test connection to the primary database)
Log in to the replicate data server and execute the $SYBASE/RAX-15_1/scripts/sybase/ase_drop_test_replicate_table.sql script to drop the test replicate table.
Use your IBM DB2 Universal Database access tool (such as Command Line Processor) to log in to the IBM DB2 Universal Database server and execute the $SYBASE/RAX-15_1/scripts/ibmudb/ udb_drop_test_primary_table.sql script to drop the test primary table.
