Target implementation checklist - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

This checklist covers all the tasks required to preparing the target operating environment and configure Straight Db2/z Replication. It assumes two things: First that a Db2 subsystem exists on the target platform. Second, that the Db2/z Log Reader Capture has been configured and tested on the source platform, see that Implementation Checklist .

# Task Sample JCL z/OS Control Center
  Prepare Environment
1 Perform the base product installation on the Target System Various  
2 Modify Procedure Lib (PROCLIB) Members N/A  
3 Verify that the Connect CDC SQData product has been Linked SQDLINK  
4 Bind the Db2 Package BINDSQD/  
5 Verify APF Authorization of LOADLIB N/A  
6 Create ZFS directories if running a Controller Daemon on Target System ALLOCZDR  
7 Identify/Authorize Operating User(s) and Started Task(s) N/A  
  Environment Preparation Complete
  Engine Configuration Tasks
1 Collect DDL for tables to be replicated and Create Target tables N/A  
2 Generate Public/Private Keys for Engine, Update Auth Key File on Source System NACLKEYS  
3 Create Straight Replication Script SQDPARSE *
4 Prepare Engine JCL SQDATA *
  Engine Configuration Complete
  Verification Tasks  
1 Start the Db2/z Capture agent and SQDAEMON on Source System Various *
2 Start the Engine on Target System SQDATA  
3 Apply changes to the source tables using SPUFI or other means. N/A  
4 Verify that changes were captured and processed by Engine N/A  
  Verification Complete  

The following sections focus on the Engine Configuration and communication with the Source platform Controller Daemon. Detailed descriptions of the other steps required to prepare the environment for Connect CDC SQData operation are described in previous sections.