Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Connecting to DB2 via JDBC (missing jar)

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
Labels (2)
13 Replies
Anonymous
Not applicable

Hi  GiacomoPerticone,
Have you already checked document about:TalendHelpCenter:Install external modules?
Best regards
Sabrina
Anonymous
Not applicable

Hi Sabrina,
Yes I did, but as said before maybe my issue is on finding the right jar files.
Although I have tried to install manually another jar file (__ https://help.talend.com/search/all?query=Installing+external+modules&content-lang=en?focusedCommentI...) and the process didn't work.
Can you please help me to fix these issues?

Update.
I managed to find by myself the right place where to download and the package.
___https://www-01.ibm.com/marketing/iwm/iwm/web/signup.do?source=swg-dm-db2trial&S_TACT=M1610PPW&lang=en_US&S_PKG=ov12916
Installing the complete version you'll get those three jars.
Anonymous
Not applicable

Hi Talend Team, 
We have also encountered this one. We are trying load data into a DB2 database, but when we tried to create a metadata connection, we are prompted to install the three jar files( db2jcc.jar,  db2jcc_license_cisuz.jar,  db2jcc_license_cu.jar). We dont know where to acquire these Jar files. By the suggestion of this Talend Article, it is stated that these Jars are external modules that needed to be MANUALLY installed in order to establish connection to their respective database. What we dont know is that, Is there a particular DB2 studio that needs to be installed in order to acquire these jar files?(Enterprise edition perhaps?). We have been using DB2 Express C and IBM Data Studio for our DB2 database. We have also been using Talend Data Fabric 6.3.1
Any help with this is gladly appreciated. 
Regards,
Locke
christ_eprimo
Contributor
Contributor

setting required to false still works at version 7.1.1