You can load Change Data Capture (CDC) policies into a database using the OpenEdge Management console. You can use the .cd file that contains the dump data of CDC table policies that you selected while dumping and their corresponding field policies, and load it into a database.

In case of a failure in loading the data, an error .e file is created and stored in the $OEMgmt\work\files.dir directory.

To load CDC policies using the OpenEdge Management console:

  1. From the OpenEdge Management console menu, select Database Administration > Go to Database Administration.
    The Database Administration page appears.
  2. From the list of database connections, select the database to which you want to load CDC policies. .
    The database connection home page appears.
  3. In the Data Administration section, click Load CDC policies (.cd file).
    The Load Change Data Capture policies (.cd file) page appears.
  4. In the Change data capture policies (.cd file) field, click CHOOSE FILE to browse and select the .cd file that you want to load.
  5. In the Acceptable Error Percentage field, either type or use the up and down arrows to specify the error rate that is acceptable to the management console to load a .cd file into a database.
    For example, if you specify an error rate of 10 percent, the management console must successfully load 90 records from every set of 100 records. If the error rate exceeds, the management console terminates the loading process and places the bad records in the error .e file.
  6. Click LOAD.
    The Confirm task for CDC load policies window appears.
  7. Specify a name for the task of loading or use the default name db-name - load CDC policies.
  8. Click:
    • COMMIT & MONITOR to confirm loading the selected file and monitor the loading procedure in the Change Data Capture Monitor Dump and Load page.

      In this page, the Data Summary section provides details of the task such as the name of the task, the connected database, the task start and end time, and the progress percentage of the task. You can click REFRESH to reload the page with most current information.

      The Monitor Database section provides information about each policy that is loaded and their corresponding error messages, if any.

    • COMMIT to confirm loading the selected file and view the task details in the Database Administration Tasks page.
    • CANCEL to cancel the loading procedure and return to the Load Change Data Capture policies list page.