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
|