Registering tables and views as SQL Replication sources

With SQL Replication, you identify the tables and views that you want to use as replication sources by registering them.

When you register a particular table or view for replication, you create a source of available data that you can later use with different targets for various purposes. The administration tasks in this section help you set up the control information that defines how data is captured from each source based on your replication goals.

When you register a source, you identify the table or view that you want to use as a replication source, which table columns you want to make available for replication, and the properties for how SQL replication captures data and changes from the source.

For SQL Replication, you can register the following objects as sources:

• A DB2® table
• A non-DB2 relational table through a nickname
• A subset of the data in a table (DB2 or non-DB2 relational)
• A view over a single table (DB2)
• A view that represents an inner join of two or more tables (DB2)