Staging configuration option

With the staging option, the CDC Replication user ID must have all of the privileges for installing the external stored procedure except for write access to the APF-authorized library. An administrator must copy the load module from the staging library to the APF-authorized library.

Adding an instance

The following input fields have special values for the staging 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 the staging library.

Upgrading an instance

When an instance is started for the first time after you upgrade to a new build, the external stored procedure is installed into the staging library but the instance fails to start. An administrator must copy the CHCRLRSP load module from the staging library to the APF-authorized library. The instance should restart successfully after the load module is copied.

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.