IBM AS/400e User Manual

IBM Licensed Programs: Database Products
534 AS/400e System Handbook
The IBM DataPropagator Relational consists of the following autonomous components:
• Administration
– Control Center: Included in
DB2 Connect Personal Edition .
– Command Line: Commands can be used to create DataPropagator Version 1
registrations and subscriptions. The Control Center or DPRTOOLS must be used for
administration of DB2 DataPropagator Version 7.1.
• Capture: Captures changes made to data on replication sources.
• Apply: Reads previously captured changed data and applies it to target tables.
The Administration component for the DB2 DataPropagator Version 7.1 is called the
Control
Center
. The Control Center is the integrated administration tool for DB2 Universal Database
Version 7.1 and includes replication administration. The Control Center runs on OS/2,
Windows NT, Windows 95, and Windows 98 platforms and does not require a local DB2
database. The Control Center is included in the
DB2 Connect Personal Edition box. A single
user license of DB2 Connect Personal Edition is shipped with DB2 DataPropagator Version
7.1.
The Control Center is used to:
• Define tables as sources, called
replication sources
• Define views and join views as replication sources
• Define target table definitions, called
replication subscriptions
• Clone replication subscriptions to other servers
• Remove replication sources or subscriptions no longer needed
Whenever a replication request is submitted from the Control Center, such as defining a
replication source, the processing information is generated as SQL statements. Statements
can be run immediately or saved to a plain ASCII file. The statements can be edited and run
at a later time from a replication folder object in the Control Center.
Deferred SQL files customization of the replication tasks and provides the flexibility as to
when and how the SQL files are run.
The
Capture component captures changes made to data in tables defined as replication
sources by reading the database log or journal, without any changes, and asynchronously to
business applications. The captured changes are placed in staging tables.
IBM DataPropagator Relational Capture for AS/400 supports the Remote Journal Function,
which is available with OS/400 V4R2 and later. This function can significantly reduce the CPU
and DASD consumption on the primary production system, by making it possible to off load
the data capturing process to a different system. Capture for AS/400 also supports the
ALIAS
feature in SQL which is available beginning with V4R5 of OS/400.
The
Apply component reads the changed data, previously captured and stored in a staging
table, and applies it to the target tables. Apply components can also read data directly from

IBM AS/400e Specifications

General

Brand	IBM
Model	AS/400e
Category	Server
Language	English