DB2 connection show 0 tables

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

I tried both 5.4.0 and 5.3.1

[Anonymous]

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

[Sebastiao_Qlik]

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?

[Anonymous]

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 ?

[Anonymous]

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

[Sebastiao_Qlik]

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.

[Anonymous]

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

[Sebastiao_Qlik]

Thanks. We're going to check that.