Solved

DB2 JDBC drivers from IBM

Posted on 2008-10-17
12
1,642 Views
Last Modified: 2013-12-01
I intend to use IBM's DB2 JDBC drivers to connect to our corporate DB2 databases. But I have been stopped citing that the DB2 drivers are not free to be used in production.

I scoured the IBM website and did various google searches, but just could not find any information that says the DB2 jdbc drivers are not free. (On the contrary I found that the DB2 drivers are free when used with Apache Derby).

Can someone provide me a link or more information about where I can buy the DB2 jdbc (Type 4) drivers? Also any idea how much it costs?

Additional points if someone can suggest an alternative: We are considering StarSQL, how good / reliable is it? Can it in someway be better than the IBM DB2 jdbc drivers?
0
Comment
Question by:anokun7
  • 4
  • 3
  • 3
  • +1
12 Comments
 
LVL 27

Assisted Solution

by:tliotta
tliotta earned 100 total points
Comment Utility
anokun7:

Since I have no idea what your "corporate DB2 databases" consist of, I can't be sure. However, under IBM i (and previous i5/OS and OS/400), the basic product licensing that applied to JDBC drivers came from the system license for the networking access product. There was no associated JDBC client-side license issue.

Now, there are client licensing elements in the full network access product for IBM i; they just don't include JDBC.

Further, I don't even need to use the JDBC from there. If I chose, I could go:

http://jt400.sourceforge.net/

As noted above, I don't know about your DB2. But for my main use, I can go fully open source if I want to; and fixes are almost always put into jt400 before being distributed with the "official" product.

Technically, I don't need even the open source (for IBM i). IBM documents the sockets protocols to IBM i host servers. I can simply write my own communications functions. (For some simple, experimental stuff, I've done that.)

So, please describe more fully your technical/business requirements. I suspect things will be cheaper than you've been told.

Tom
0
 
LVL 13

Author Comment

by:anokun7
Comment Utility
Sure - I can explain a bit more. We host some financial data that is on a DB2 database. The DB2 database contains tables, actually we use just one view that is all. The DB2 database is itself hosted on a mainframe (OS390). Our application is a java unix app and we need to connect to the DB2 view to populate a drop down...

I also forgot to mention that my company is very much against open source. So that is out of question. If it is true, then I would like to point out to the management that the IBM DB2 jdbc type 4 drivers are indeed free to use in production and that there would be no problem.

I hope I have provided you with adequate information.
0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 200 total points
Comment Utility
0
 
LVL 13

Author Comment

by:anokun7
Comment Utility
Thank you momi_sabag.

But I am not able to ascertain in the link where it says that the IBM DB2 jdbc drivers are free. I need something to prove such is the case. It talks about the usage of the jdbc driver and also the necessity of the license file. So it can be interpreted that the license file can only be purchased from IBM for a cost... I am trying to get more information about the cost and the restrictions on the usage.
0
 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
i think you get it once you download the db2 client and the client is free
0
 
LVL 13

Author Comment

by:anokun7
Comment Utility
Any link to prove to management that the client is indeed free? Thanks so much.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 27

Expert Comment

by:tliotta
Comment Utility
I'm not sure that "proof" exists of something that is 'not'; but I think that evidence exists:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/c0022612.htm

Scan the page for the word [ license ]. You should be able to locate this sentence -- "License terms that allow free redistribution of DB2 Runtime Client with your application." Note that the DB2 Runtime Client includes JDBC as a common database access interface (according to a bullet point above the license point).

Tom
0
 
LVL 5

Expert Comment

by:Brian Chan
Comment Utility
Well, technically, IBM's own DB2 JDBC driver is NOT a free item. However, you are entitle to download it at NO CHARGE if you have the DB2 product  licence (not sure on DB2 express-c edition as it is free). So if you use it in-house and you have a db2 licence, go to www.ibm.com, under the tab "Support & download" > "Download" > "fixes, updates & drivers", search for it and you can download it from there. you need a login for the site.
0
 
LVL 27

Expert Comment

by:tliotta
Comment Utility
bpnchan:

Technically, I agree. And maybe anokun7 can clarify whether or not their "corporate DB2 databases" are running on licensed installations of DB2...

Tom
0
 
LVL 13

Author Comment

by:anokun7
Comment Utility
Yes - of course, Corporate databases can be safely assumed to be running on licensed DB2 databases.

So it seems if the DB2 installation itself is licensed, all other client tools / drivers are automatically free?
0
 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
yes, client tools are free
0
 
LVL 5

Assisted Solution

by:Brian Chan
Brian Chan earned 200 total points
Comment Utility
Pretty sure that when your production is licensed, you got a lot of tools to download which come at no charge. After all, my recommended that you check up with IBM's support, they should be tell you the absolute truth. Apart from that, if you have the IBM customer number associated with your DB2 copy, they will be able to tell you if there is any extra component ( or in IBM's term: Extenders) your license entitled to, like DB2 XML Extender & DB2 Spatial Extender. Our company had licensed to DB2 workgroup edition, and some other extender candies and HADR. It all associated with the licese you got.
If you don't find access to the licensing information, you could possibly ask your dba to check it out for you.
Hope this helps :).

.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now