1 Reply Latest reply on Apr 7, 2015 1:59 PM by thatJeffSmith-Oracle

    DB2 on zOS support in SQL Developer?

    Gediminas

      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?