Five Stars

db2 connection

last post before leaving this product ...

I have installed  di open studio on windows  6.3.1

when defining a connection  to db2 luw - product still requests the  license file for db2 connect (z/db2 or as400/db2)

I try to setup a connecttion to db2 linux - this driver is free and installed

is this all the free support you get from talend..  i am happy I did not payed the license for talend yet... we probably have to select anoyher product..  received many mails from marketing.. I will assign someone.. someone will have a look...   promises..   no contact ...

I can not get this product to work with db2..

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Ten Stars

Re: db2 connection

 

what the problem?

 

1) all related XML files:

Screen Shot 2017-05-26 at 9.55.41 AM.png

 

2) change true for false

Screen Shot 2017-05-26 at 9.57.20 AM.png

 

3) be happy

Screen Shot 2017-05-26 at 9.56.58 AM.png

 

 

 

need more? (want use Repo connection meta-data?)
and You sure You not forget revert this if will need?

 

cp db2jcc4.jar db2jcc_license_cisuz.jar

cp db2jcc4.jar db2jcc_license_cu.jar

Screen Shot 2017-05-26 at 10.39.53 AM.pngScreen Shot 2017-05-26 at 10.40.34 AM.png

 

-----------
20 REPLIES
Moderator

Re: db2 connection

Hello,

Thanks for posting your issue here.

Talend Studio requires specific third-party Java libraries or database drivers (.jar files) to be installed to connect to sources and targets. Those libraries or drivers, known as external modules, can be required by some of Talend components or by some connection wizards or by both. Due to license restrictions, Talend may not be able to ship certain external modules within Talend Studio.

Sorry for the inconvenience.

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.
Five Stars

Re: db2 connection

thanks for the update, but I think you don not understand my issue..although it is in English

I fully understand that you can not supply all drivers

I installed required files - as documented by IBM and this working for ALL other products.

your product is requesting files that are completely NOT needed, only if you connect to Z/db2 or 400/db2, and this is NOT my case, i connect to linux/db2

the connection can NOT be defined as this message requires the files to be installed - which in that case would require a license.

the driver files for LUW are FREE and everybody can download them for FREE

I hope this is more clear..

best regards, Guy

Moderator

Re: db2 connection

Hi,

We know your problem about the jar files db2jcc_licence_cisuz.jar and db2jcc_licence_cu.jar.

Could you try to create a "Generic JDBC connection" in the connection wizard and use your own JDBC driver therein(db2jcc4.jar)?

So far, there is a jira issue about:https://jira.talendforge.org/browse/TUP-1615

Feel free to post your issue on talend bug tracker.

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.
Four Stars

Re: db2 connection

If you install IBM Data Studio - http://www-03.ibm.com/software/products/da/data-studio - you will find the driver. On Linux it resides in <installdir>/DS4.1.1/dsdev/jar

 

Note

You must not use this driver to connect to mainframe DB2 without a valid licence.

Ten Stars

Re: db2 connection


Przytula wrote:

last post before leaving this product ...

 


all possible ... but because it is was Your last post ... and look like You already leave product Smiley Wink
we will be bored :-)



Screen Shot 2017-05-17 at 12.12.26 PM.png

-----------
Five Stars

Re: db2 connection

thanks for the update : BUT

the problem is NOT getting the driver - these can be downloaded from IBM for free

 

the problem is talend product requesting drivers that are NOT for free AND NOT needed for this type of connection

best regards, Guy Przytula

Ten Stars

Re: db2 connection

Sure, but this is not biggest issue of Talend to be a reason stop use product :-)

yes, it is well knowing "problem" migrated from version to version ... but ... 

 

 

-----------
Five Stars

Re: db2 connection

Hi,

I want to connect Talend to IBM DB2. Talend requires 3 jar as you know. I don't find the db2jcc_license_cisuz.jar. Can you help me, please?

 

thank's

Five Stars

Re: db2 connection

this jar is part of db2 connect license  and not for free

talend should NOT request this file if connecting to luw database, only if connecting to z/db2 or db2/400 which is not my case either

they claim it is a known bug, but not corrected yet..

still waiting (for weeks)

best regards, Guy

Five Stars

Re: db2 connection

and the problem is still NOT resolved in latest version 6.4... still requesting jar

waiting for weeks, months, still not able to use the product

best regards, Guy Przytula

Highlighted
Ten Stars

Re: db2 connection

 

what the problem?

 

1) all related XML files:

Screen Shot 2017-05-26 at 9.55.41 AM.png

 

2) change true for false

Screen Shot 2017-05-26 at 9.57.20 AM.png

 

3) be happy

Screen Shot 2017-05-26 at 9.56.58 AM.png

 

 

 

need more? (want use Repo connection meta-data?)
and You sure You not forget revert this if will need?

 

cp db2jcc4.jar db2jcc_license_cisuz.jar

cp db2jcc4.jar db2jcc_license_cu.jar

Screen Shot 2017-05-26 at 10.39.53 AM.pngScreen Shot 2017-05-26 at 10.40.34 AM.png

 

-----------
Five Stars

Re: db2 connection

looks better..

 

was this also available in 6.3 ?

if so - why could talend not reply like this immediately and only now after 2 months

best regards, Guy przytula

Ten Stars

Re: db2 connection

Hi Guy,

 

I work with DB2 since 6.0, sure it same and early

 

Think it little misunderstanding - where You are.

 

There are no Talend staff there, Sabrina not a technical staff, some time Shong answer, but I do not know Talend rotations.

 

All other there - community members, same as You or me. Some of them extremely experienced.

 

"Open Source Community Edition" mean not only free, but as well - supported by community members.

So, when I saw Your message - I answer ... may be little with humour ;-) but it because You start Your post very serious ... like leave You product or not related to us (open You a secret - on other side of world - for me it absolutely ... not important :-) )

 

If You have subscription version, or test trial or have definitely error - use Jira for open ticket

 

Forum it more for share ideas, tricks, experience, but not a channel by Talend Support

For all question what I ask there or old version of forum - the best what I receive from Talend, it was:
"Your question transferred to Our ESB expert" ... and never answers more :-)

 

But I meet there other people, found a lot of ideas for me when I start use Talend

I read forum near 4 years, and answer only 1 - a lot of answers already there, just need search before write, including answer about DB2, because this I also found somewhere on old forum in comments and test, may be not clean and easy and I add few own iterations for found solution ... 

 

low priority for tasks, sure because it not extremely popular product. AS400 DB2 work like charm with Talend, mainframe is also all on support, so the problem have a small number of clients who use LUW in production with Talend ... and this is not a big number of them who not resolve the problem


Best regards, Vlad

-----------
Five Stars

Re: db2 connection

Thank you for the answer.

 

I've edited all entries related to xml files for the JAR: CISUZ because I have the two others jar DB2JCC4 AND DB2JCC...CU:


TMondrianInput_java: cisuz required = false
TDB2BulkExec_java: cisuz required = false
TDB2Connection_java: cisuz required = false
TDB2Input_java: cisuz required = false
TDB2Output_java: cisuz required = false
TDB2Row_java: cisuz required = false
TDB2SCD_java: cisuz required = false
TDB2SCDELT_java: cisuz required = false
TDB2SP_java: cisuz required = false

 

And in the others two xml file:
MavenUriIndex
tCreateTable_java


I commented the import of jar cisuz.

 

I attach a screenshot to show the result. The problem is the same. If I go to create a new connection to db2, Talend ask me the "cisuz" jarCattura.PNG.

Ten Stars

Re: db2 connection

if You want use metadata connection - just copy one file to other and install

Talend not use this files - just check

 

Guy absolutely right - it stupid error with many years history ;-)

but at least it not stop real work

 

-----------
Five Stars

Re: db2 connection

You mean that when I create a db2 connection and Talend ask me for the "cisuz" Jar I can attach the db2jcc4 jar?
Ten Stars

Re: db2 connection

from my original post You miss 1 part:

 

need more? (want use Repo connection meta-data?)
and You sure You not forget revert this if will need?

 

cp db2jcc4.jar db2jcc_license_cisuz.jar

cp db2jcc4.jar db2jcc_license_cu.jar

 

You can copy 

db2jcc_license_cu.jar to db2jcc_license_cisuz.jar

in case if You have 2 from 3 

-----------
Five Stars

Re: db2 connection

Ok thanks, I did not understand that with "copy" it is mean that the db2jcc must be passed to Talend when it ask db2jcc...cisuz.jar.

Thank you for the reply
Ten Stars

Re: db2 connection

welcome !

 

I spend many hours for search solution in 2015 when start work with LUW DB2 :-)

-----------
Five Stars

Re: db2 connection

I have seen the same problem

If I define the connection in the job part (db2row....) ok

If I try to create connection (to be reused) it still requests the jar files

cp files corrected that

best regards, Guy Przytula