Skip to Main Content

Analytics Software

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!

Error reverse-engineering from IBM DB2 UDB

User10316075-OracleFeb 8 2010 — edited Nov 16 2010
Everyone,

I'm trying to reverse-engineer from IBM DB2 UDB. My connection in topology appears to be correct (I get a "Successful Connection" when I test). When I attempt to reverse-engineer, I get the following error message:

The Technology or the Driver does not support Reverse Engineering
com.ibm.db2.jcc.b.SqlException: The required stored procedure is not installed on the server. Contact your DBA.

I cannot see the table or any table when I go to the "Selective Reverse" tab (I get the same error message as above). Below are the drivers that I copied to my drivers directory:

db2jcc_javax.jar
db2jcc_license_cisuz.jar
db2jcc.jar

There's also a COM\ibm\db2 folder that contains a lot of other files and folders. The COM\ibm\db2 folder exists in my drivers directory.

I'm using the Standard Reverse, but I also tried using the RKM SQL JYTHON which gives me the same error.

Can anyone help me with what I'm doing wrong? Is there a SQL stored procedure that needs to be created in DB2? Am I not using the correct drivers? The DB2 DBA does not know what the problem is.

Version of ODI is ODI 10.1.3.5
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2010
Added on Feb 8 2010
2 comments
1,228 views