Please enable JavaScript to view this site.

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.