DB2 database in Oracle SQL developer

database oracle db2 mainframe oracle-sqldeveloper
Frantumn picture Frantumn · Apr 20, 2012 · Viewed 47.3k times · Source

I've heard it's possible to connect to a mainframe DB2 database with a client like Oracle SQL developer. I've looked on-line and can't seem to find the connector files needed to do this in SQL developer. Can anyone direct me to a link to make this work? Or tell me if im just looking for the wrong thing to begin with. I've got the connector working with MySQL databases in Oracle, so I assumed it would be similar for a DB2 database.

Answer

Sireesh Yarlagadda picture Sireesh Yarlagadda · Feb 18, 2016

To enable DB2 in SQL Developer, you need to pull out the db2jcc.jar

Go to "Oracle SQL Developer" - "Tools" - "Preferences" - > Third Party JDBC Driver

enter image description here

My ORACLE SQL Developer Version is 4.1.1.19 (it mostly works for many versions)

After adding that jar to third party JDBC Drivers. Click on "New Connection".

You should be able to find DB2 Option.

enter image description here

Related questions

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such …

Read More
Differences between DB2 and Oracle

We had a talk with colleagues about databases yesterday as we will have a DB2 education in few weeks. I'm wondering, what are the differences between DB2 and Oracle as two major enterprise solutions? Are there any limitations in comparison …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More