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

  • Talend Installer
Tags (1)
13 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

 

 

 

Four 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

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.

Seven 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

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

Seven 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

Four 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

Four 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

Seven 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

 

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

Seven 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

-----------