Specifying source tables, target tables, and privileges for the subscription

You must define at least one table for every JDBC subscription. If you specified more than one table for the subscription, these tables will be synchronized in the same order that you added them when you created the subscription. The list of tables on the Define Replication Subscription window shows this order.

You must not specify the same source and target tables in two different subscriptions. If you want to create two subscriptions that replicate the same source table, use different target tables.

This task is part of the larger task of creating a JDBC subscription. When you have completed these steps, return to Creating a JDBC subscription.

Procedure

To add a table to the subscription:

  1. On the Identification page of the JDBC Subscription notebook, click Define subscription. The Define Replication Subscription window opens.
  2. In the Define Replication Subscription window, click Add. The Add Table window opens.
  3. In the Add Table window, use the Table list to select the replication source to add to this subscription.

    Click Filter to change the source filter used to limit the available tables in the table list. The Filter window opens.

    The % symbol is a wildcard. Typing % in the Source schema and Source table fields displays all available tables in the table list.

  4. For Lotus Domino, click Advanced on the Add Table window to select a primary key for the appropriate columns. For more information see, Configuring the JDBC driver to access Lotus Domino data.
  5. In the Target schema field, specify the schema that the table will have on the dispositivo portátil. If you do not specify a schema, the system uses the schema of the source table by default.
  6. In the Target table field, specify the name that the table will have on the dispositivo portátil. If you do not specify a name, the system uses the name of the source table by default.
  7. Under Access privileges, select the SQL access privileges that you want users of this subscription to have for this replication source. For example, if some of your visiting nurses are allowed to insert, update, or delete data, but trainee nurses are allowed only to view the data, you need to create two different subscriptions to handle the difference in access privileges. These subscriptions must use separate mirror tables. For more information about SQL access privileges, see the DB2 Universal Database Administration Guide: Design and Implementation.
  8. Optional: Select the Encrypt on device checkbox. This enables encryption on the mobile device database. (Encrytion is only available on WinCE, Win32, and Palm OS client platforms).
  9. Optional: Select the Use Constraints defined in selected DB2 source checkbox. This enables the constraints from the selected DB2 source table for the target table.
  10. Optional: Select the Use Indexes defined in selected DB2 source checkbox. This enables the indexes from the selected DB2 source table for the target table.
  11. Optional: In the Source table space field, click the down arrow and select the table space. If you do not select a table space, then DB2 Everyplace will create the table in the default table space.
    Nota:
    This option is only available for DB2 sources. DB2 on iSeries is not supported.
  12. Optional: In the Mirror table space field, click the down arrow and select the table space. If you do not select a table space, then DB2 Everyplace will create the table in the default table space.
  13. Click Add to add the replication source to the subscription. Click Close to close the Add Table window.

Conceptos relacionados

Tareas relacionadas