Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB2 on zOS support in SQL Developer?

GediminasApr 7 2015 — edited Apr 7 2015

I managed to connect to DB2 on zOS by adding third party JDBC drivers from IBM (db2jcc4.jar and db2jcc_license_cisuz.jar) in SQL Developer preferences. During connecting I get an error:

DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SCHEMATA, DRIVER=4.18.60

The connection actually works and I can successfully execute SQL statements afterwards, however autocompletion and browsing the list of tables doesn't, which renders the tool pretty useless.

So is this a faulty setup on my part, or does SQL Developer not support DB2 on zOS yet?

If that is the case, are there any plans/roadmap for at least minimal support of DB2?

This post has been answered by thatJeffSmith-Oracle on Apr 7 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2015
Added on Apr 7 2015
1 comment
1,359 views