This checklist covers all the tasks required to preparing the target operating environment and configure Straight Db2 Replication. It assumes two things: First that a Db2 subsystem exists on the target platform. Second, that the UDB Log Reader Capture has been configured and tested on the source platform.
| # | Task |
| Prepare Environment | |
| 1 | Perform the base product installation on the Target System |
| 2 | Identify/Authorize/Prepare Operating User(s) |
| 3 | Verify Execution Authorization of SQData components |
| 4 | Bind the SQData Db2 Package |
| 5 | Create SQData Variables Directories |
| Environment Preparation Complete |
| Engine Configuration Tasks | |
| 1 | Create Application Directory Structure |
| 2 | Collect DDL for tables to be replicated and Create Target tables |
| 3 | Generate Public/Private Keys for Engine, Update Auth Key File on Source System |
| 4 | Create Straight Replication Script |
| 5 | Prepare Engine Shell Script |
| Engine Configuration Complete |
| Verification Tasks | |
| 1 | Start the UDB Capture agent and SQDAEMON on Source System |
| 2 | Start the Engine on Target System |
| 3 | Apply changes to the source tables using db2cmd or other means. |
| 4 | Verify that changes were captured and processed by Engine |
| 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 SQData operation are described in previous sections.