The following sequence of steps will specify the requirements of DB2 Everyplace
on the Data Propagator components, and expects that the reader reference the
DataPropagator Guide and Reference to ensure that the components are created
correctly.
Prerequisites
Ensure that the source and mirror databases exist and are cataloged on
the machine(s) which will be running the DB2 UDB Replication Center and the
DB2 Everyplace Mobile Devices Administration Center.
Procedure
- Open the DB2 UDB Replication Center.
- Create the Capture Control Tables on the source database.
- Create the Capture and Apply Control Tables on the mirror database. The
capture schema on the mirror database must be ASN.
- Enable both the source and mirror Capture Control Server databases for
replication. If a database does not already have LOGRETAIN=RECOVERY, then the Backup Wizard will open, and a backup should be initiated.
- Register tables in the source database for replication.
- The Row Capture Rule must be to capture
changes to all columns.
- Full refresh of the target table must be allowed.
- If the source table will be replicated to more than one target table,
regardless of whether or not the target tables are part of a DB2 Everyplace
subscription, Capture changes from replica target
table must be selected.
- The Conflict Detection Level must be Standard
detection.
- To create a DataPropagator subscription set for the mirror database use
the Set information page of the Create Subscription Set window.
- In the Set name field, type the name of
the Subscription Set which must be the name of the DB2 Everyplace Data Propagator
Table Subscription.
- In the Apply qualifier field, type the
name that you want to use for the apply qualifier.
- In the Capture control server alias field,
type the name of the source database.
- In the Capture schema field, click the
down arrow and select the schema that you used when Capture was configured.
- In the Target server alias field, type
the name of the mirror database.
- Select the check box next to Activate the subscription
set.
- Set the Data blocking factor = 0.
- Select the check box next to Allow Apply to
use transactional processing for set members, and set the Number of transactions applied before Apply commits to a non-zero value
(20 is a suggested value).
- Open the Source-to-target page.
- Add the members of the subscription set as Replica Target types.
- Ensure that the source table primary key is created as the target table
primary key in the Target-Table Index
creation for each table.
DB2 Everyplace will initiate the full refresh during the initial replication.
Related tasks
Related reference