Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DB2 JDBC drivers from IBM

Posted on 2008-10-17
12
Medium Priority
?
1,682 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
TCP/IP Network Protocol Cheat Sheet

TCP/IP is a set of network protocols which is best known for connecting the machines that make up the Internet. The truth is that TCP/IP is one of the oldest network protocols and its survival is mainly based on its simplicity and universality.

 
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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

In its Critical Driver Installation Order document, Intel stresses that this sequence be followed:   1       Fresh Operating System Installation 2       Latest Service Pack or Patch 3       Intel® Chipset Software Installation Utility (INF Utili…
A while back when OPSMGR 2012 was released we were very excited about getting it into our environment and upgrading our 2007 implementation,  we started our planning and we then proceeded with our implementation. All went as planned & our system …
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

721 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