Use this page to to specify information about the replication step.
The following replication types are available:
User copy - Produces target tables that are read-only copies of the replication source with no replication control columns added. These tables look like regular source tables and are a good starting point for replication. They are the most common type of target table.
Point-in-time - Produces target tables that are read-only copies of the replication source with a timestamp column added. The timestamp column is originally null. When changes are replicated, values are added to indicate the time when updates are made. Use this type of table if you want to keep track of the time of changes.
Base aggregate - Produces read-only tables that summarize the contents of a source table. Base aggregate replication tables are useful for tracking the state of a source table on a regular basis. Aggregate tables use SQL column functions (such as SUM and AVG) to compute summaries of the entire contents of the source tables or of the recent changes made to source table data.
Change aggregate - These tables work with the change data in the control tables, not with the contents of the source table. This type of replication is useful for tracking the changes made between each Apply program cycle.
Staging table - These read-only tables contain data from committed transactions. Also called consistent change-data tables (CCD tables), these tables contain different data if they are condensed, noncondensed, complete, or noncomplete.
A condensed staging table contains only the most current value for a row. The Apply program only updates rows that are already in condensed tables. Condensed tables are useful for staging changes to remote locations and for summarizing hot-spot updates before they are replicated to targets.
A noncondensed staging table contains a history of changes to a row. The Apply program appends rows to noncondensed tables. Noncondensed staging tables are useful for auditing purposes.
A complete staging table contains all the rows that you want to replicate from the source table.
A noncomplete staging table is empty when it is created, and rows are appended as changes are made to the source table.
Use this page to specify processing parameters for the replication step.
Database type
Valid values are:
DB2 UDB for AS/400 CISC
DB2 UDB for AS/400 RISC
DB2 UDB for OS/390
DB2 UDB for Windows NT (default)
DB2 UDB for OS/2
DB2 UDB for AIX
DB2 UDB for HP-UX
DB2 UDB for Sun Solaris
DB2 UDB for VM
DB2 UDB for SCO UnixWare
DB2 UDB for VSE
DB2 UDB EEE
DataJoiner