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.
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
|