To uninstall CDC Replication

Procedure

Remove the metadata tables in Db2®.
All tables owned by the CHCUserID should be removed from DB2. Use SPUFI to issue the commands in Db2, or use your preferred method for working with Db2.
Notes:
- If the CDC Replication metadata is in a separate database, you can simply drop the database in Db2.
- CDC Replication metadata is stored in a number of table spaces in Db2 that are named using the prefix assigned to the <CHCTBSPrfx> placeholder in the CHCMDMUT job that is used to create or update the metadata. The <CHCTBSPrfx> prefix is followed by three decimal digits to make the table space names unique. To drop the table spaces, issue the Db2 commands that have this format:
  DROP TABLESPACE <CHCTBSPrfx>nnn;
  where <CHCTBSPrfx> is the table space name prefix that is specified when the CHCMDMUT job was run, and nnn varies through the range of numeric suffixes for existing table spaces.
Remove the libraries and data sets.
During the CDC Replication installation, you created data sets to store CDC Replication. Refer to the jobs you used to allocate these data sets to determine the names used:
- CHDCFPAL
- CHCDFMTD
- CHCCRCCH (if you allocated a log cache)
Also during CDC Replication installation, you should have copied the SCHCCNTL, SCHCLOAD and SCHCDATA data sets from the SMP/E target data set to new data sets. Remove these data sets.
Remove the SMP/E data sets and CSI.
Remove the CDC Replication Target and DLIB library data sets. Refer to the CHCALB and CHCALLOC jobs used during the CDC Replication installation for these data set names.

If you have not accepted the product FMID, or had the option set not to delete TLIB data sets, delete them now. The names are formatted using the DSPREFIX setting in the CSI.

If you installed CDC Replication into a separate CSI, simply remove the CSI created during the installation. If you installed CDC Replication into a shared CSI, refer to your SMP/E manual to remove the software.