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
ft:lastEdition
2024-09-05
ft:lastPublication
2024-09-05T15:00:09.754973

This checklist covers the tasks required to prepare the operating environment and configure the Db2/z Log Reader Capture Data Capture Agent. Before beginning these tasks however, the base Connect CDC (SQData) product must be installed. Refer to the Installation Guide for an overview of the entire product and the z/OS installation instructions and prerequisites.

# Task Sample JCL z/OS Control Center
  Prepare Environment
1 Identify Source and Target System and Datastores N/A  
2 Confirm/Install Db2 Replication Related APARS N/A  
3 Modify z/OS Procedure Lib (PROCLIB) Members N/A  
4 Verify Product is Linked SQDLINK  
5 Bind the Db2 Package BINDSQD  
6 Verify APF Authorization of LOADLIB N/A  
7 Create ZFS Variable directories ALLOCZDR  
8 Reserve TCP/IP Ports N/A  
9 Authorize zFS User and Started Task IDs and specify MMAPAREAMAX RACFZFS  
10 Prepare Db2 for Capture DB2GRANT  
11 Generate z/OS Public/Private keys and Authorized Key Files NACLKEYS  
  Environment Preparation Complete
  Setup CDCStore Storage Agent
1 Size the Transient Storage Pool N/A *
2 Create Db2 Capture zFS Transient Data File(s) ALLOCZFS  
3 Create the CDCStore CAB file SQDCONDS *
  CDCStore Storage Agent Setup Complete
  Setup Db2 Log Reader Capture Agent
1 Configure Db2 Tables for Capture (DB Server) N/A  
2 Create Db2 Log Reader Capture CAB File SQDCONDC *
3 Prepare Log Reader Capture Runtime JCL SQDDB2C *
  Capture Agent Setup Complete
  Setup Controller Daemon
1 Create Access Control List (acl.cfg) CRDAEMON *
2 Create Agent Configuration File (sqdagents.cfg) CRDAEMON *
3 Prepare z/OS Controller Daemon JCL SQDAEMON *
  Controller Daemon Setup Complete
  Configure Apply Engine
1 Determine Requirements N/A  
2 Configure Apply Engine Environment N/A  
3 Create Apply Engine Script N/A  
  Apply Engine Configuration Complete  
  Component Verification
1 Start the Controller Daemon SQDAEMON *
2 Start the Capture Agent SQDDB2C *
3 Start the Engine SQDATA *
4 Execute Test Transactions N/A  
  Verification Complete