One Star

DB2 connection show 0 tables

I connect successfully to DB2 v9.7 on SUN, but cannot see any tables under any schema.
I tried reload without success. There are no errors.
I have DBVisualizer connecting to the same database using JDBC without problems.
Any ideas ?
10 REPLIES
Moderator

Re: DB2 connection show 0 tables

Hi,
What's your Talend Open Studio Data Quality product build version?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: DB2 connection show 0 tables

I tried both 5.4.0 and 5.3.1
Moderator

Re: DB2 connection show 0 tables

Hi,
Does it only repro on DB2? Because I made a testing for Mysql DB on 5.3.1, everything is OK with me. Feel free let me know if I missing something.
Is there any good news when you re-create a new DB connection under Metadata of DQ repository?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Employee

Re: DB2 connection show 0 tables

Could you try to create a "Generic JDBC connection" in the connection wizard?
and use your own JDBC driver therein.
Can you see the tables with this work around?
One Star

Re: DB2 connection show 0 tables

I do not have other databases to check against, and am surprised you guys didn't test with DB2.
Using my own JDBC drivers gives the same result. I think connecting is not a problem, but the way Talend interrogates the system catalog for table names.
Any other ideas ?
One Star

Re: DB2 connection show 0 tables

As an update: ODBC connection to this database works fine.
Employee

Re: DB2 connection show 0 tables

we did tests, but not on the same version and not on SUN OS.
Please, raise an issue in our bugtracker https://jira.talendforge.org.
Note: not all indicators may work with ODBC.
One Star

Re: DB2 connection show 0 tables

Did so, thank you.
Is this similar to TDI-24222 "DB2 v. 9.7 retrive schemas in pending state" ?
Employee

Re: DB2 connection show 0 tables

Thanks. We're going to check that.
Employee

Re: DB2 connection show 0 tables