Advanced Subscription Definition -- Fields and controls

Target Type page
Target Columns page
Rows page



Target Type page

" " Source table
" " Target table
" " Target table is read-only
" " Target table is replica
" " Target table is row replica
" " OK
" " Cancel

" " Source table

This field displays the name of the source table that you selected in the Define Subscription window.

" " Target table

This field displays the name of the target table that you selected or specified in the Define Subscription window.

" " Target table is read-only

Select this radio button to specify that the target table is read-only. If you select this radio button, you must select one the following read-only target types:

User copy
Contains a snapshot of the table when copied without the IBMSNAP_LOGMARKER column, which differentiates it from a point-in-time table. This choice is the default and must have a primary key.

Point-in-time
A complete, condensed copy of the source table, which must have a primary key. Contains a snapshot of the table when copied with the IBMSNAP_LOGMARKER column.

Staging table
Can be used as a source for further copies, supports a consistent data environment, provides flexibility in data distribution across a network, and becomes the source for a copy operation. If you select this target type, you can optionally append unit-of-work table columns (ASN.IBMSNAP_UOW) to the target table by selecting the Unit of Work (UOW) table columns check box. You can also use a staging table as a source for future copies.

Base aggregate
A history table in which a new row is appended for each changed row in the source table resulting in an SQL column function calculation against the existing user table. Contains data aggregated directly from a source table or point-in-time table at intervals.

Change aggregate
A history table in which a new row is appended for each changed row in the source table resulting in an SQL column function calculation against only recent change data. Contains data aggregations based on changes recorded for a source table.

" " Target table is replica

Select this radio button to specify that the target table is a replica target type that defaults to the same after-image columns and primary key fields as the source table.

" " Target table is row replica

Select this radio button to specify that the target table is a row replica target type. The row replica target type is the replica available for Microsoft Jet databases.

Row replica is a type of update-anywhere replica in which conflicts are detected row by row, not transaction by transaction. Not all DB2 UDB data types are supported by Microsoft Jet databases, therefore, some table columns may be excluded when you use row replica.

When you select a Microsoft Jet database the target type defaults to row replica. All other target types are grayed out on the Target Type page.



Target Columns page

" " Source table
" " Target table
" " Primary key
" " Column name
" " Subscribe
" " Create column
" " Change
" " Show Keys
" " OK
" " Cancel

" " Source table

This field displays the name of the source table that you selected in the Define Subscription window.

" " Target table

This field displays the name of the target table that you selected or specified in the Define Subscription window.

" " Primary key

Select this check box to specify that the selected target column is a primary key column.

" " Column name

Use this field to change existing column names and then specify which columns are selected for subscription and which columns are primary key columns.

The replication program automatically adds the default character X for each source column that you define as a before-image column in the Define as Replication Source window.

The field:

" " Subscribe

Select this check box to specify that this column be included in the subscription.

" " Create Column

Click on this push button to open the Create Column window so that you can select a column name from the list of available columns and then add it as a computed column to the Column Name list.

" " Change

Click on this push button so that you can change existing target columns or SQL expressions. The Change Column window opens.

" " Show Keys

Click on this push button to open the Show Keys window so that you can see existing primary keys from the source table. The key columns are either primary key columns, if defined, or columns from the unique indexes.



Rows page

" " Source table
" " Target table
" " WHERE
" " Examples
" " OK
" " Cancel

" " Source table

This field displays the name of the source table that you selected in the Define Subscription window.

" " Target table

This field displays the name of the target table that you selected or specified in the Define Subscription window.

" " WHERE

Type the row predicate definition for the subscription set. You can click on the Examples push button to see sample predicates.

Do not type the word WHERE. The replication program automatically provides this word.