Uninstalling IBM® InfoSphere Change Data Capture software components for shadow tables

Uninstalling InfoSphere® CDC software components for shadow tables consist of removing the installation of each software components and database objects that are created for the InfoSphere CDC instance.

To uninstall InfoSphere CDC software components:

1. Log in to the InfoSphere CDC Management Console with access-server-user.
2. Stop mirroring and end replication:
   1. Click Monitoring > Subscriptions.
   2. Right-click the subscription for shadow tables and click End Replication > Normal.
   3. Click OK.
3. Delete table mappings:
   1. Click Configuration > Table Mappings.
   2. Right-click each table mapping and select Delete.
   3. Click Yes.
4. Delete the subscription for shadow tables:
   1. Select Configuration > Subscriptions.
   2. Right-click the subscription and select Delete Subscription.
   3. Click Yes.
5. Log in to the access-server-host as a cdc-user.
6. Delete the InfoSphere CDC instance:
   1. Shut down the InfoSphere CDC instance by issuing the following commands:

      $ cd /cdc-installation-dir/bin
      $ ./dmshutdown -I cdc-instance-name

   2. Launch the InfoSphere CDC configuration tool by issuing the following command:

      $ ./dmconfigurets

   3. Type 4.
   4. Select the instance number.
   5. Type y (Yes).
   6. Exit the configuration tool by typing 6.
7. Delete the installation directory of InfoSphere CDC for DB2 for LUW. The following example shows how to delete the /cdc-installation-dir/ directory:

   $ rm -rf /cdc-installation-dir/

8. Shut down the InfoSphere CDC Access Server by issuing the following commands:

   $ cd $ cd /access-server-installation-dir/bin/
   $ ./dmshutdownserver

9. Uninstall the InfoSphere CDC Access Server by issuing the following commands:

   $ cd /access-server-installation-dir/Uninstall
   $ ./UninstallAccessServer

10. Log on to the DB2 server as the root user or become the root user on the DB2 server.
11. Delete the cdc-user. The following example shows how to remove this user on AIX® operating systems:

    # rmuser -p cdc-user
    # rm -rf cdc-user-home-dir

    The following example shows how to remove this user on Linux operating systems:

    # userdel -r cdc-user

12. Log in as a user with an administrator role to the management-console-workstation where you installed the InfoSphere CDC Management Console
13. Remove the InfoSphere CDC Management Console by using the Windows Control Panel applet.
14. Log in to the DB2 server as a db2-cdc-user.
15. Drop the InfoSphere CDC metadata tables:
    1. Connect to the database by issuing the following command:

       $ db2 connect to db2-database-name

    2. Determine the metadata tables to be dropped by issuing the following command:

       $ db2 list tables for schema db2-metadata-schema-name | grep TS_

       For a list of all metadata tables, see InfoSphere CDC for DB2 for LUW metadata tables.
    3. Drop each metadata table that you found in step 15.b by issuing the following command:

       $ db2 drop table db2-metadata-schema-name.metadata-table-name