My Oracle Support Banner

Migration from DB2 on IBM z/OS (OS/390) to Oracle (Doc ID 200288.1)

Last updated on APRIL 11, 2018

Applies to:

Oracle Database Gateway for DB2 - Version 9.2.0.4 to 10.2.0.3 [Release 9.2 to 10.2]
IBM z/OS on System z
Oracle Transparent Gateway for DB2
IBM z/OS (OS/390)
Checked for relevance on 14-Aug-2009


Purpose

To discuss the migration of DB2 data on IBM z/OS (OS/390) to Oracle.

Scope

Anyone considering migrating a DB2 database on IBM z/OS (OS/390) to an Oracle database.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Migration from DB2 on IBM z/OS (OS/390) to Oracle
 
The 10.2 Transparent Gateway for DB2 that runs on the z/OS platform is not suitable for migrating a complete DB2 database on IBM z/OS (OS/390) to an Oracle database.
There are many more issues to migrating a DB2 system than just moving the actual data from DB2 tables to Oracle tables. As in Oracle, a DB2 database has many more types of objects apart from tables - views, permissions, stored procedures and so on.
Although the gateway can be used to move actual data from DB2 tables to Oracle tables, it cannot be used to migrate these other objects without much manual intervention, if at all.

1. SQL*Developer

The latest version of SQL*Developer can be used to migrate from DB2 but only when running on Unix, Linux and Windows platforms.
It does not currently support migrating DB2 running on IBM z/OS (OS/390).
 2. Other options

The following note -
 3. Goldengate

Another option is to use Oracle GoldenGate to connect to DB2 and replicate data.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.