Synchronization Server Help


JDBC and Upload Subscription notebook -- Fields and controls

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.

Figure dsyh017 not displayed. Identification page
Figure dsyh017 not displayed. Source page
Figure dsyh017 not displayed. Mirror page
Figure dsyh017 not displayed. Subscription sets page
Figure dsyh017 not displayed. Put only
Figure dsyh017 not displayed. OK
Figure dsyh017 not displayed. Cancel


Figure dsyh016 not displayed.

Identification Page

Figure dsyh017 not displayed. Name
Figure dsyh017 not displayed. Description
Figure dsyh017 not displayed. Adapter
Figure dsyh017 not displayed. Encryption Level
Figure dsyh017 not displayed. Target database
Figure dsyh017 not displayed. Define Subscription

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. Description

Optional: Type a description for the subscription. The description must be 128 characters or less.

Figure dsyh017 not displayed. Adapter

Specify the adapter to use with this subscription. The adapter must support the type of subscription you are creating.

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. 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.


Figure dsyh016 not displayed.

Source page

Use this page to provide database URL, driver, user ID and password information to gain access to the source database.

Figure dsyh017 not displayed. Database URL
Figure dsyh017 not displayed. Driver
Figure dsyh017 not displayed. User ID
Figure dsyh017 not displayed. Password
Figure dsyh017 not displayed. Verify password
Figure dsyh017 not displayed. Test connection

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. Driver

Use this field to select the database driver to use with this subscription.

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. Verify password

Use this field to type the password again exactly as you typed it in the Password field.

Figure dsyh017 not displayed. Test connection

Click this push button to test the connection to the database specified in the Database URL field.


Figure dsyh016 not displayed.

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.

Figure dsyh017 not displayed. Database URL
Figure dsyh017 not displayed. Driver
Figure dsyh017 not displayed. User ID
Figure dsyh017 not displayed. Password
Figure dsyh017 not displayed. Verify password
Figure dsyh017 not displayed. Figure dsyh024 not displayed.
Figure dsyh017 not displayed. Test connection

Figure dsyh017 not displayed. Database URL

For JDBC only. Use this field to select the JDBC Database for the mirror database. Click the Figure dsyh024 not displayed. push button to open the Select Mirror Database window.

Figure dsyh017 not displayed. Driver

This field is disabled. IBM DB2 UDB local is always used for JDBC for the mirror database.

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. Password

Use this field to type the password associated with the user ID.

Figure dsyh017 not displayed. Verify password

Use this field to type the password again exactly as you typed it in the Password field.

Figure dsyh017 not displayed. Figure dsyh024 not displayed.

Click the Figure dsyh024 not displayed. 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.

Figure dsyh017 not displayed. Test connection

Click this push button to test the connection to the database specified in the Database URL field.


Figure dsyh016 not displayed.

Subscription Sets page

Figure dsyh017 not displayed. Available subscription sets
Figure dsyh017 not displayed. Selected subscription sets
Figure dsyh017 not displayed. >, >>, <, <<
Figure dsyh017 not displayed. Create

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. 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.

Figure dsyh017 not displayed. >, >>, <, <<

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:

>
Click this push button to assign the current subscription to the subscription sets that you selected in the Available subscription sets list. The subscription sets move from the Available subscription sets list to the Selected subscription sets list.

>>
Use this push button to assign the current subscription to all subscription sets appearing in the Available subscription sets list. All subscription sets move from the Available subscription sets list to the Selected subscription sets list.

<
Click this push button to remove the current subscription from the subscription sets that you selected in the Selected subscription sets list. The subscription sets move from the Selected subscription setslist to the Available subscription sets list.

<<
Use this push button to remove the current subscription from all subscription sets appearing in the Selected subscription sets list. All subscription sets move from the Selected subscription sets list to the Available subscription sets list.

Figure dsyh017 not displayed. 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.


Figure dsyh016 not displayed.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]