Connecting to DB2 via JDBC (missing jar)

[_AnonymousUser]

Hi there,
am using Talend Open Studio for Data Integration 5.4. When trying to connect to DB2 Express-c 10.5 database it is also required to install "db2jcc_licence_cisuz.jar" (Open Studio and DB2 are running on Linux). As far as I know this is part of DB2 Connect and required to connect to DB2 on mainframes. Why is it required by Open Studio if I don't want to connect to DB2 on mainframe? Since I don't have DB2 Connect, how can I use DB2 on Linux without Open Studio prompting for the missing jar-file all the time.
Thanks and greetings

[_AnonymousUser]

works fine for me by using "generic jdbc" and "db2jcc4.jar". however, new problem: cannot retrieve schemas, cause I cannot see any tables under schemas
same as in topic 32811 ( http://community.talend.com:80/t5/Design-and-Development/resolved-Could-not-create-the-Java-virtual-...), but am running Open Studio and DB2 on Linux (CentOS 6.5)
any idea what to do?

[Anonymous]

Hi,
Have you checked the document TalendHelpCenteretting up a JDBC connection for your Talend Open Studio for Data Integration 5.4.?
Best regards
Sabrina

[Anonymous]

I would not recommend using the generic connection. You will run into trouble while reading metadata and also the type mapping does not work correctly.
The DB2 driver configuration has a misconfiguration in Talend because the Modules view show both license files:
db2jcc_licence_cisuz.jar
db2jcc_licence_cu.jar
as needed but only one is needed. This looks like a bug.
You can fix that by removing the line with the need first license file in:
/path/to/TOS/plugins/org.talend.designer.components.localprovider_5.4.1.r111943/components/tDB2Connection/tDB2Connection_java.xml
and all other DB2 components you use.
Alternatively you can change the attribute to REQUIRED="false"

[_AnonymousUser]

@xdshi: yes, checked the document and can connect to db2, but still no tables under the schemas; I get result with "select * from sysibm.tables", so there should be no access issues
@jlolling: thx for your hint, searched all files for "db2jcc_license_cisuz.jar" and removed all lines, however Open Studio is still asking for the file
any other ideas how to solve the two problems?

[_AnonymousUser]

this is how the connection is configured

and here the retrieve schema window without tables

btw retrieving the tables is working fine with mysql, just checked it

[Anonymous]

The missing library will be referenced from all DB2 components - like the tDB2Input. You have to remove the line in this component also.
You can try to copy+rename your current working license file into the wanted file. This prevents you from connecting to main frame servers but this is not your use case.
Yes I know this bug. It is a bug what is caused by a changed behavior from DB2 in the last releases (starting from 10.1). I will file a bug report. Currently I am working on a patch to solve this issue (for release 5.1.1 because this is our current release).

[_AnonymousUser]

found out that db2jcc_licence_cisuz.jar is delivered with IBM Data Studio, so I used it from there; deleting the references from all DB2 components didn't work out
tried now TOS DI and DB2 v10.5 Enterprise Server (not express-c) on Windows Server 2008 64 bit, problems with retrieving schemas remains but is a little bit different: synonyms can be retrieved but no tables and views. seems to be a general problem / bug in retrieving schemas from DB2 databases (maybe just from the newer versions)
where can I find and change the SQL queries for retrieving schemas from DB2 databases?

[Anonymous]

What you can do at the moment is:
You can retrieve the schema for the input components be the "Get Schema" function. This works well.
You have to define the SQL for your self - on my opinion - it is much better than using the bloated generated statements from studio. After that klick on retrieve schema and thats it.
I have created a bug ticket:
https://jira.talendforge.org/browse/TUP-1615
By the way, to retrieve the metadata the JDBC API provides methods. Using self defined queries for it is only a workaround and never an good idea, because you have to keep up to date every changes.
For the output you can do a workaround:
create a select which contains all output related columns and retrieve the schema like described above. Then copy&paste the schema to your output component.

[Anonymous]

Hello there,
I am using Talend DI v6.2, but I'm struggling to set a DB2 connection.
There are  few jar modules missing:
db2jcc.jar
db2jcc_license_cisuz.jar
db2jcc_license_cu.jar
which I presume should be into JDBC 3.0 
I have downloaded 'Microsoft SQL Server JDBC Driver 3.0' and tried to map those module to the unpack folder (clicking into the action button) but it seems Talend DI GUI doesn't map automatically the package.
PS. I have tried from http://www.java2s.com/Code/Jar/d/Downloaddb2jccjar.htm but doesn't allow the download (do you have a repository for all the required drivers).
Can you please help me setting this?
Thank you