SQL Developer Data Modeler

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!

SQL developer to iseries DB2 Connection

c6330348-a1e8-404e-913f-f8b3a8620414Feb 2 2017 — edited Feb 3 2017

Hi,

I need to connect to DB2 Database(i series) from Oracle Sql Developer 4,1,3,20 Version and then further create a data model. Am totally new to this and need some guidance on the same.

I tried creating a JDBC connection using the files db2jcc.jar, db2jcc_license_cisuz and the test shows successful and connects for first time. But when we expand the database to see the table names it shows an error.

DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSSH200;00;ELSEG400 , DRIVER=3.59.81

Vendor code -805

Need urgent help.

Also any other approach to connect the DB2 database to sql would be okay if it works fine.

Any directions would be appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2017

Added on Feb 2 2017

#error, #jdbc

2 comments

2,015 views