My Oracle Support Banner

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

Last updated on MARCH 19, 2024

Applies to:

Oracle Database Gateway for DB2 - Version to [Release 9.2 to 10.2]
Oracle GoldenGate - Version to [Release 19]
IBM z/OS on System z
Oracle Transparent Gateway for DB2
IBM z/OS (OS/390)


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


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


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

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