IBM Books

Replication Guide and Reference

Performing a Replication Scenario

The hypothetical scenario in this section and the following sections enables you to acquire preliminary experience using the Control Center and the Capture and Apply programs. This scenario walks you through the steps above using hypothetical data to copy a simple DB2 source table to a target DB2 database for Windows NT. This type of copy is known as a user copy, which is a complete, condensed copy of the replication source table without the timestamp columns.

This scenario uses the sample source table shown in Table 4. This is the DEPARTMENT table in the SAMPLE database that is contained in the DB2 Universal Database. You can create the SAMPLE database from the First Steps icon in the DB2 Universal Database.

Table 4. Sample Source Table Rows
DEPTNO DEPTNAME MGRNO ADMRDEPT
A00 Spiffy Computer Service 000010 A00
B01 Planning 000020 A00
C01 Information Center 000030 A00
D01 Development Center - A00
D11 Manufacturing Systems 000060 D01
D21 Administration Systems 000070 D01
E01 Support Services 000050 A00
E11 Operations 000090 E01
E21 Software Support 000100 E01

Nomenclature for the scenario is as follows:

DEPARTMENT
Source table name

DEPARTCOPY
Target table name

SAMPLE
Source server database

COPYDB
Target server database

COPYDB
Control server database

DEPTQUAL
Apply qualifier

DB2
Instance name

This scenario accomplishes the following objectives:

To set up the environment to run this scenario for Windows NT, do the following:

  1. Create the SAMPLE database to be used as the source server database.

  2. Create a database called COPYDB to be used as the target and control server database.

  3. Verify that these databases appear in the Control Center.

The following sections explain the steps required to define a user copy for DEPARTMENT:

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]