Automatic configuration option

With the automatic option, the CDC Replication user ID must be granted all of the privileges for installing the external stored procedure.

Adding an instance

The following input fields have special values for the automatic configuration option:

  • Database Username: A user ID with privileges for both normal operation and configuration and upgrade.
  • Database Metadata Schema: The schema for creating and executing the external stored procedure.
  • Load Library: The name of an APF-authorized library to which the user has write access.

Upgrading an instance

When an instance is started for the first time after you upgrade to a new build, the external stored procedure is updated automatically.

Editing an instance

If you edit an instance and change the WLM environment or load library but not the schema, then CDC Replication skips the installation and therefore does not use the new WLM environment or write the load module to the new load library. In this case, to force a complete installation you must drop the CHCRLRSP procedure from Db2 before editing the instance.