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.
Zadania pokrewne
Informacje pokrewne