You can dump Change Data Capture (CDC) policies from your database into a .cd file using the OpenEdge Management console. You can select an individual CDC policy, a list of CDC policies, or all CDC policies irrespective of their state—current, pending, or previous—to dump, and specify the destination directory where you want to dump them. You can also select all the current or pending CDC policies defined for your database and dump them at once.
When you dump CDC policies, a .cd file is created with the name of the database, db-name.cd, from which the policies are dumped, and stored in the current OpenEdge work directory. However, you can specify a name and destination directory for the file. The .cd file contains the dump data of CDC table policies that you selected and their corresponding field policies. You can use this .cd file to load data into a database.
In case of a failure in dumping the data, an error .e file is created and stored in the same directory where the .cd file is stored.
To dump 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 from which you want to dump CDC policies. .
The database connection home page appears.
3. In the Data Administration section, click Dump CDC policies (.cd file).
The Dump Change Data Capture policies (.cd file) page appears.
4. In the File name field, specify the name you want for the .cd file or use the default name db-name.cd.
5. In the Dump directory field, enter the location of the destination directory where you want to store the .cd file or use the working directory.
6. In the Code page field, specify the code page format in which you want the CDC policies to be dumped or use the default format ISO8859-1.
7. Select the Overwrite existing file check box to allow overwriting the existing .cd file, if any, and then click NEXT.
The Dump Change Data Capture policies list page appears with a list of current, pending, and previous CDC policies available for the connected database. The CDC policies are alphabetically sorted by their names.
8. From the list, select the CDC polices that you want to dump.
When selecting the CDC policies, you can:
Select an individual CDC policy.
Select the All Current check box to select all current CDC policies.
Select the All Pending check box to select all pending CDC policies.
Note: When dumping multiple policies, you must select only one policy per source table as the OpenEdge Management console does not allow selecting more than one policy per source table.
Note: When dumping a previous policy, note that it is stored as a pending policy in the .cd file.
9. Click DUMP.
The Confirm task for CDC dump policies window appears.
10. Specify a name for the task of dumping the selected CDC policies or use the default name db-name – dump CDC policies.
11. Click:
COMMIT & MONITOR to confirm dumping the selected policies and monitor the dumping 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 dumped and their corresponding error messages, if any.
COMMIT to confirm dumping the selected policies and view the task details in the Database Administration Tasks page.
CANCEL to cancel the dumping procedure and return to the Dump Change Data Capture policies list page.
Select an individual CDC policy.