Enabling SQL statements in Management Console

CDC Replication lets you execute SQL statements after it applies a table-level clear or refresh operation to a target table.

About this task

You can specify SQL statements in the Additional SQL dialog box in Management Console. By default, this feature is disabled in CDC Replication for security reasons. You can enable this feature by creating a table called TS_SQL_EXECAUTH in the database where you installed CDC Replication. The structure of the table is unimportant, and you must create the table using the same schema as the metadata tables during the configuration of CDC Replication. For more information about specifying SQL statements in Management Console, see Specifying SQL to control refresh operations in your Management Console documentation.

Procedure

  1. Locate the database on the target server that you created for CDC Replication. Depending on how you are using CDC Replication, this is the database you want CDC Replication to replicate to or from.
    Note: During installation, IBM® Data Replication places metadata tables in the database necessary for CDC Replication processes.
  2. If you want to enable the specification of SQL statements, create a table named TS_SQL_EXECAUTH in the database.
    Note: The table can have any structure and must be created in the schema you specified when you configured CDC Replication.