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.