This help applies to both the Create JDBC Subscription and Edit JDBC Subscription notebooks, and the Create Upload Subscription and Edit Upload Subscription notebooks. The pages and fields on the Create and Edit notebooks are the same. Some fields cannot be changed in the Edit JDBC Subscription and Edit Upload Subscription notebooks.
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.
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.
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.
Source page
Use this page to provide database URL, driver, user ID and password information to gain access to the source database.
Database URL
Use this field to type the Database URL. The correct form for the driver selected in the Driver field is shown. Replace the variables in braces with the information to connect to the database. For example, the default Database URL for IBM DB2 UDB local is jdbc:db2:{database}. Replace {database} with the name of the DB2 database that you plan to use.
Driver
Use this field to select the database driver to use with this subscription.
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.
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.
Test connection
Click this push button to test the connection to the database specified in the Database URL field.
Mirror page
For JDBC only. Use this page to provide a JDBC database URL, JDBC driver, user ID and password to use to gain access to the mirror database.
Database URL
For JDBC only. Use this field to select the JDBC Database for the
mirror database. Click the
push button to open the Select Mirror Database window.
Driver
This field is disabled. IBM DB2 UDB local is always used for JDBC for the mirror database.
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 the subscription 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.
Password
Use this field to type the password associated with the user ID.
Verify password
Use this field to type the password again exactly as you typed it in the Password field.
Click the
push button to open the Select Mirror Database window for JDBC
subscriptions. When you select a mirror database in the Mirror Database
window, its database URL appears in the Database URL field.
Test connection
Click this push button to test the connection to the database specified in the Database URL 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.