topic Re: db2 connection in Installing and Upgrading

db2 connection

Anonymous — Sat, 16 Nov 2024 09:51:32 GMT

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

Re: db2 connection

Anonymous — Thu, 27 Apr 2017 04:30:48 GMT

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

Re: db2 connection

Anonymous — Thu, 27 Apr 2017 07:00:08 GMT

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

Re: db2 connection

Anonymous — Thu, 27 Apr 2017 09:33:53 GMT

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

Re: db2 connection

Anonymous — Tue, 16 May 2017 04:08:52 GMT

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.

Re: db2 connection

vapukov — Wed, 17 May 2017 01:16:42 GMT

@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
we will be bored 🙂

Re: db2 connection

Anonymous — Wed, 17 May 2017 12:20:42 GMT

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

Re: db2 connection

vapukov — Wed, 17 May 2017 12:23:35 GMT

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

Re: db2 connection

Anonymous — Thu, 25 May 2017 15:10:43 GMT

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

Re: db2 connection

Anonymous — Thu, 25 May 2017 16:33:17 GMT

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

Re: db2 connection

Anonymous — Thu, 25 May 2017 16:55:40 GMT

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

Re: db2 connection

vapukov — Thu, 25 May 2017 23:02:06 GMT

what the problem?

1) all related XML files:

2) change true for false

3) be happy

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

Re: db2 connection

Anonymous — Fri, 26 May 2017 15:32:11 GMT

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

Re: db2 connection

vapukov — Sat, 27 May 2017 03:46:40 GMT

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

Re: db2 connection

Anonymous — Wed, 31 May 2017 11:11:25 GMT

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" jar.

Re: db2 connection

vapukov — Wed, 31 May 2017 11:17:06 GMT

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

Re: db2 connection

Anonymous — Wed, 31 May 2017 11:19:54 GMT

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

Re: db2 connection

vapukov — Wed, 31 May 2017 11:24:16 GMT

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

Re: db2 connection

Anonymous — Wed, 31 May 2017 11:31:59 GMT

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

Re: db2 connection

vapukov — Wed, 31 May 2017 11:34:52 GMT

welcome !

I spend many hours for search solution in 2015 when start work with LUW DB2 🙂