Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

DB2 JDBC drivers from IBM

Posted on 2008-10-17
12
Medium Priority
?
1,685 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 400 total points
ID: 22746528
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
ID: 22746972
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 800 total points
ID: 22747336
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 13

Author Comment

by:anokun7
ID: 22748114
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
ID: 22755216
i think you get it once you download the db2 client and the client is free
0
 
LVL 13

Author Comment

by:anokun7
ID: 22756931
Any link to prove to management that the client is indeed free? Thanks so much.
0
 
LVL 27

Expert Comment

by:tliotta
ID: 22773249
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
ID: 22782820
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
ID: 22783169
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
ID: 22785907
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
ID: 22785918
yes, client tools are free
0
 
LVL 5

Assisted Solution

by:Brian Chan
Brian Chan earned 800 total points
ID: 22791099
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One good source is the manufacturer's web site. Even though the device operating system is changing, the hardware isn't. Going to the support site and looking at the Vista drivers provides a starting point for identifying system hardware for which d…
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

885 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