Connect CDC SQData

#

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