Please enable JavaScript to view this site.

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

Note, some organizations do not permit third party software to be installed on the UDB database server platform. Connect CDC SQData supports remote capture of UDB from another platform using essentially the same configuration described below. The configuration tasks that must be performed on the database server and Capture platforms are identified below.

#

Task

Prepare Environment

1

Identify Source and Target System and Datastores (DB Server)

2

Identify/Authorize Operating User(s)

3

Prepare Client Platform

4

Create Variable Directories

5

Bind the UDB (Db2/LUW) Package

6

Prepare UDB (Db2/LUW) for Capture

7

Reserve TCP/IP Ports

8

Generate Public / Private Keys and Authorized Key File

Environment Preparation Complete

 

CDCStore Storage Agent Setup

1

Size the Storage Pool

2

Create the CDCStore CAB file

CDCStore Storage Agent Setup Complete

 

Setup UDB Log Reader Capture Agent

1

Configure UDB Tables for Capture (DB Server)

2

Configure UDB Log Reader Capture Agent

3

Configure Log Reader Capture Shell Script

Capture Agent Setup Complete

 

Setup Controller Daemon

1

Generate Public / Private keys

2

Create Authorized Key File

3

Create Access Control List

4

Create Agent Configuration File

5

Configure Controller Daemon Shell Script

Controller Daemon Setup Complete

 

Configure Apply Engine

1

Determine Requirements

2

Configure Apply Engine Environment

3

Create Apply Engine Script

Apply Engine Configuration Complete

 

Component Verification

1

Start the Controller Daemon

2

Start the Capture Agent

3

Start the Apply engine

4

Execute Test Transactions

Verification Complete