Docs Menu
Docs Home
/
Relational Migrator
/
Connect to Databases

Connect to DB2

On this page

  • About this Task
  • Steps
  • Database Connection String
  • Connect to DB2
  • Learn More

This page shows how to save a new DB2 connection from the Connections page. You can use a saved connection for any Relational Migrator task that requires connecting to a database.

About this Task

To save a new DB2 connection in Relational Migrator, you must:

  • Identify your database connection string or database information.

  • Connect to DB2.

Important

To plan your migration and map your DB2 schema to a MongoDB schema, you must connect using an account with the correct read permissions.

To migrate data, you must connect to your DB2 database using a service account with the required permissions.

For information on database configuration and required permissions, see Configure DB2.

Steps

Database Connection String

The DB2 connection string looks like:

jdbc:db2://<hostname>:<port>/<database>;

For example, the mydb2database DB2 database running on localhost at port 50000 uses the following connection string:

jdbc:db2://localhost:50000/mydb2database;

Note

To learn more about DB2 connection strings, see:

  • DB2 Connection URL Syntax

  • Connection Configuration Properties

Connect to DB2

1

Add a connection

In the list of Relational connections, click + Add connection.

2

Select the database type

In the Database type drop-down, select DB2.

3

To enter a connection string directly:

  1. Above JDBC URI, enable the Enter URI manually toggle.

  2. Paste your connection string into the JDBC URI.

4

To create a connection string, enter the following:

Field
Value

Host

The host IP or DNS name.

Port

The port number.

Database

The database name. Required.

Username and Password

The credentials to use for authentication.

Checking Save password saves the password securely on your machine, so you don't have to enter the Username and Password again when using the saved connection.

5

Identify the connection

Enter a Connection name and optional Environment tag.

Environment tags color code and organize connections for convenience. Leaving the drop-down empty is the same as selecting the "None" tag.

6

(Optional) Click Test connection

Relational Migrator attempts to authenticate and connect to the database.

7

Click Save

The saved connection is available for use in all jobs and projects.

Learn More

Back

Configure Sybase

Next

Configure DB2