Providing a user ID and password for the subscription

All subscriptions defined against a source database share the same user ID and password to gain access to the database. If this is the first subscription created against the source database, you need to specify this user ID and password. To do this, type the following values on the Authentications page of the Create DataPropagator subscription notebook:

• A valid DB2 Universal Database user ID. Ensure that this ID has, at a minimum, the SQL privileges that you granted for the subscriptions defined against the database. For example, if you granted the SQL UPDATE privilege in the subscription, the user ID must have UPDATE privileges defined for the source database.
• A valid DB2 Universal Database password for the user ID. Type the password again in the Verify password field.
  • For DataPropagator subscription, the user ID requires DBADM privileges.
  • For JDBC subscriptions, the user ID requires SYSADM or DBADM privileges.

For DataPropagator Subscriptions, the Sync Server creates a password file from this information that DataPropagator uses to access the source database. The password file is stored in the directory where the Sync Server runs.

Related concepts

• What is a replication source?
• Data filtering and replication
• Improving replication performance

Related tasks

• Using the Mobile Devices Administration Center
• Creating a DataPropagator subscription
• Identifying the subscription
• Specifying the encryption level
• Mapping the source to the target
• Identifying the mirror database
• Adding a replication source
• Creating a filter for replicated data
• Batching synchronization requests