This help applies to both the Create DataPropagator Subscription and Edit DataPropagator Subscription notebooks. The pages and fields on the Create DataPropagator Subscription and Edit DataPropagator Subscription notebooks are the same. Some fields cannot be changed in the Edit DataPropagator Subscription notebook.
Identification Page
Name
Type a descriptive, unique 1- to 18-character name for the subscription.
The system converts the name that you type to uppercase upon saving it in the administration control database. After the name is saved in the control database, you cannot rename the subscription. To change the name, you must first delete the existing subscription, then create a new subscription with the new name.
Description
Optional: Type a description for the subscription. The description must be 128 characters or less.
Adapter
Specify the adapter to use with this subscription. The adapter must support the type of subscription you are creating.
Encryption level
Specify the encryption level to use during data transfer. Limited encryption provides basic security with a small performance penalty. Strong encryption provides enhanced security with a larger performance penalty.
Source database
Specify the database where the source table resides. The source database must be cataloged.
You can type the name of the source database or you can click the
push button to select from a list of cataloged databases.
Mirror database
Specify the database where the mirror table resides. A mirror table is a database on the mid-tier server identical to the source database from the source system.
Target database
Specify the database where the target table resides. A target table is a database receiving replicated data from a source system.
This field automatically defaults to the name that you typed in the Source database field. You can override this default only if this is the first subscription defined against this source database.
Click this push button to view a list of cataloged databases from which you can choose a source database.
Define Subscription
Click this push button to open the Define Subscription window, so you can specify the replication source table and other aspects of the subscription.
Authentication page
Use this page to provide a user ID and password that all subscriptions will use to gain access to the source and mirror databases that you specified on the Identification page. You must specify the same user ID and password in the Source database and Mirror database fields of the page.
User ID
Use this field to type a user ID that has the appropriate SQL privileges and database authorities to accomplish all the actions that you defined for all subscriptions against the database. For example, if you granted the SQL UPDATE privilege in the subscription, this user ID must have the UPDATE privilege defined for the source database.
You must specify the same user ID in both the Source database and the Mirror database fields.
Password
Use this field to type the password associated with the user ID.
You must specify the same user ID in both the Source database and the Mirror database fields.
Verify password
Use this field to type the password again exactly as you typed it in the Password field.
Subscription Sets page
Available subscription sets
The Available subscription sets list shows existing subscription sets available to which the current subscription can be assigned. To assign the subscription to a subscription set, select the subscription set and click >. Assign all available subscription sets at one time by clicking >>. The subscription sets move to the Selected subscription sets list.
If no subscription sets appear in the Available subscription sets list, create an subscription set by clicking Create.
Selected subscription sets
The Selected subscription sets list shows the subscription sets to which the current subscription is assigned. To remove the subscription from a subscription set, select the subscription set and click <. To remove the subscription from all subscription sets at one time, click <<. The subscription sets move back to the Available subscription sets list.
>, >>, <, <<
Use these push buttons to change the list of subscription sets displayed in the Available subscription sets list and Selected subscription sets list. You can use:
Create
Click Create to create a new subscription set without closing the current subscription. The Create Subscription Set notebook opens.
If the Create push button is disabled, check whether you already have the Create Subscription Set notebook open. You can open the Create Subscription Set notebook from within the Create DataPropagator Subscription notebook, unless a Create Subscription Set notebook is already open.