topic Re: DB2 connection show 0 tables in Data Quality

DB2 connection show 0 tables

Anonymous — Thu, 14 Nov 2013 16:47:49 GMT

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 ?

Re: DB2 connection show 0 tables

Anonymous — Fri, 15 Nov 2013 07:44:02 GMT

Hi,
What's your Talend Open Studio Data Quality product build version?
Best regards
Sabrina

Re: DB2 connection show 0 tables

Anonymous — Sun, 17 Nov 2013 05:40:31 GMT

I tried both 5.4.0 and 5.3.1

Re: DB2 connection show 0 tables

Anonymous — Mon, 18 Nov 2013 07:26:10 GMT

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

Re: DB2 connection show 0 tables

Sebastiao_Qlik — Mon, 18 Nov 2013 11:59:19 GMT

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?

Re: DB2 connection show 0 tables

Anonymous — Mon, 18 Nov 2013 15:23:15 GMT

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 ?

Re: DB2 connection show 0 tables

Anonymous — Mon, 18 Nov 2013 22:46:32 GMT

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

Re: DB2 connection show 0 tables

Sebastiao_Qlik — Tue, 19 Nov 2013 14:30:22 GMT

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.

Re: DB2 connection show 0 tables

Anonymous — Tue, 19 Nov 2013 16:38:16 GMT

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

Re: DB2 connection show 0 tables

Sebastiao_Qlik — Wed, 20 Nov 2013 09:32:12 GMT

Thanks. We're going to check that.

Re: DB2 connection show 0 tables

Sebastiao_Qlik — Wed, 20 Nov 2013 10:01:16 GMT

for later reference: https://jira.talendforge.org/browse/TDQ-8357