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.
Prerequisites
You must specify the source and mirror databases. For upload subscriptions, no mirror database is required.
Procedure
On the Source page of the Create JDBC Subscription notebook, provide the
following information:
- Database URL
- Type the JDBC Database URL. The correct form for the JDBC 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 you plan to use. For example, for Microsoft SQL
Server example, you can use:
jdbc:microsoft:sqlserver://myhost.mycompany.com:1433;SelectMethod=cursor,
DatabaseName=myDatabase
- Driver
- Select the JDBC database driver to use with this subscription.
- User ID
- Type a valid source database user ID. Ensure 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.
- ΑΦ:
- The user requires SYSADM or DBADM authority because
subscription creation requires it to execute the SQL: CREATE TABLE, CREATE
TRIGGER, CREATE INDEX, and LOCK TABLE.
- Password
- A valid source database password for the user ID.
- Verify Password
- Use this field to type the password again exactly as you typed it in
the Password field.
- Control Table space
- The DB2 Everyplace Sync Server uses this field to create one of its
internal control tables for replication. When the source has been registered
to Sync Server subscription, you cannot edit this value. Control Table Space
field is only valid for DB2 source.
- Note for OS390 source:
- You can enter database_name.tablespace in a text entry
field. If you only specify one name (no "dot" in between), DB2 Everyplace
will consider it is a table space name in the default database.
Click Test connection to verify the source database
settings.
Related concepts
Related tasks