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.
- Note:
- 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