IBM i Series Handbook

IBM Licensed Programs: Database Accessories 527
IBM Licensed Programs: Database Accessories
DB2 DataPropagator Version 7.1 on the iSeries contains commands (in PTF SF65370) to
handle the creation and removal of registrations and subscriptions.
Deferred SQL files customizing 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. The captured changes are placed in staging
tables.
IBM DataPropagator Relational Capture for AS/400 supports the Remote Journal Function.
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
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
source tables, for example, for a full refresh. Supporting update and refresh copying provides
greater flexibility and automation in a replication environment.
The Apply component also enhances the data to your specifications as it copies data to the
targets. The full power of SQL can be exploited to:
• Create new columns
• Summarize data
• Translate data
• Join data
Run-time processing statements can be defined using SQL statements and stored
procedures before and after the Apply program processes the replication subscription. The
run-time processing statements can be run at the source server before the answer set is
retrieved and at the target server before and after the answer set is applied. The stored
procedures use the SQL CALL statement, which is newly supported by IBM Replication,
without parameters. The run-time procedures are executed together in a single unit-of-work.
Acceptable SQLSTATEs can be defined for each processing statement as well.
The Apply component allows the creation of:
• Read-only copies
–
User copy tables : Represent an exact copy of the source table
–
Point-in-time tables : Represent source data at a particular point in time plus some
overhead columns
– History tables

IBM i Series Specifications

General

Operating System	IBM i
Form Factor	Rack, Tower
Storage	SSD and HDD options
Security	compliance
Virtualization	IBM PowerVM
CPU	POWER processors
Scalability	Scale-up