Docs Menu
Docs Home
/
Relational Migrator
/ /

Configure Migration Prerequisites for DB2

On this page

  • Before you Begin
  • About this Task
  • Steps

To run migration jobs from a DB2 source database, the target database requires creating a specific schema and a specific table within the schema in the database you are migrating. If Relational Migrator determines the database needs configuration changes, it automatically generates a SQL script with the required changes. It is recommended to have a Database Administrator (DBA) review the commands in this script and perform their execution on the database server.

Download and install the DB2 jdbc driver to the correct Relational Migrator directory. For details, see the Installation on a Local Machine for your operating system.

  • This page covers the details of the SQL scripts automatically generated by Relational Migrator.

  • Relational Migrator automatically detects configuration settings when connecting to your database and generates the appropriate SQL statements.

  • Relational Migrator does not create any indexes on your DB2 instance to facilitate migration jobs. The create index creation permission is not required.

  • Creating the required schema and table have no impact on database performance.

  • Relational Migrator does not support BLOB, CBLOB or DBCLOB columns of DB2 tables. If this feature is important to you, create or upvote the feature request on feedback.mongodb.com.

  • Relation Migrator only supports snapshot migration jobs for DB2 connections.

1

Use the following statements to create the schema:

CREATE SCHEMA "ASNCDC";
2

Use the following statements to create the table:

CREATE TABLE "ASNCDC"."IBMSNAP_REGISTER"
(SYNCHPOINT INTEGER, CD_NEW_SYNCHPOINT INTEGER);

Back

Sybase