Before you can replicate data, you need to create and
configure your servers, ensure that they can connect to each other, and create
replication objects such as registrations and subscription sets.
Planning for SQL Replication
When planning for SQL replication, you might need to consider
planning for migration, memory, storage, conflicts, source systems,
code page conversion, and performance.
Configuring servers for SQL Replication
Before you can replicate data, you must create and configure
your servers and ensure that they can connect to each other.
Subscribing to sources for SQL Replication
After you register tables or views as replication sources,
you can define a subscription for your target tables or views so that
they receive the initial source data and subsequent changes.
Replicating special data types in SQL Replication
When you replicate special data types, such as LOB, ROWID,
or non-DB2 data types, you should be aware of certain conditions and
restrictions. In some cases, you might have to perform additional
setup steps to get SQL replication to work with these data types.
Subsetting data in an SQL Replication environment
Replication usually involves subsetting. It might involve
the choice of certain columns and rows to replicate from a source
table when you register a replication source. It might involve the
choice of certain registered columns to replicate to each target table
when you create subscription sets.
Customizing and running SQL scripts for replication
To create control tables, register source tables, and create
subscription sets and members, you must run SQL scripts that are generated
by the Replication Center and ASNCLP command-line program. You can
run the SQL scripts using the Replication Center or you can run them
from a DB2® command line. If necessary, you can modify the SQL scripts
to meet your needs.
How the SQL Replication components communicate
The various replication components run independently of
one another, but rely on one another for information that each stores
in the replication control tables to communicate with one another.