Topic
  • 14 replies
  • Latest Post - ‏2015-07-23T05:08:48Z by mor
amccarl
amccarl
73 Posts

Pinned topic How do I find the right DB2 JDBC Driver?

‏2013-06-11T18:39:40Z |
The DB2 Universal JDBC driver versions are included with DB2 products.  A table with the complete listing is available here.  The article also includes notes on how to check for the version. 
 

This is also covered by the technical article 1363866, http://www.ibm.com/support/docview.wss?uid=swg21363866

  • amccarl
    amccarl
    73 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2013-06-14T14:26:00Z  
    Hello!  We've had a number of clients respond through feedback to our technical documents indicating that they have further questions or comments that require additional dialogue.  Unfortunately, our feedback is anonymous, so unless an email address or other contact information is included, we have no way to get back in touch with you.
     
    Within DB2 support, the management team asked if we could somehow link our documents to the forums so that we could invite more discussion - like this!   As a start, we chose about 30 technical articles and "seeded" the forum with initial entries so that we could have a starting place for conversation.  The documents have now been updated with links to the forums as well.  
     
    Hopefully, we will make DB2 support better by providing more interaction around our technical information!
     
  • CFBM_David_Kantor
    CFBM_David_Kantor
    2 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2013-09-11T18:20:28Z  
    • amccarl
    • ‏2013-06-14T14:26:00Z
    Hello!  We've had a number of clients respond through feedback to our technical documents indicating that they have further questions or comments that require additional dialogue.  Unfortunately, our feedback is anonymous, so unless an email address or other contact information is included, we have no way to get back in touch with you.
     
    Within DB2 support, the management team asked if we could somehow link our documents to the forums so that we could invite more discussion - like this!   As a start, we chose about 30 technical articles and "seeded" the forum with initial entries so that we could have a starting place for conversation.  The documents have now been updated with links to the forums as well.  
     
    Hopefully, we will make DB2 support better by providing more interaction around our technical information!
     

    Is there a compatibility matrix available which indicates which JDBC drivers are compatible with accessing various versions of DB2 database servers? Specifically, I'd like to know if the driver shipped with 10.5 (driver version 3.66.46) can be used to connect to a DB2 10.1 database?

  • nivanov1
    nivanov1
    231 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2013-09-11T19:12:25Z  

    Is there a compatibility matrix available which indicates which JDBC drivers are compatible with accessing various versions of DB2 database servers? Specifically, I'd like to know if the driver shipped with 10.5 (driver version 3.66.46) can be used to connect to a DB2 10.1 database?

    http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_c0024897.html

  • CFBM_David_Kantor
    CFBM_David_Kantor
    2 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2013-09-11T21:53:28Z  
    • nivanov1
    • ‏2013-09-11T19:12:25Z

    Thanks very much for the link.  So based on the info, it should be fine to use the 10.5 driver to access a 10.1 database.

  • Chandru_419
    Chandru_419
    1 Post

    Re: How do I find the right DB2 JDBC Driver?

    ‏2013-09-18T09:34:25Z  

    Hi,

    We recently migrated DB2v9.6 to v10.1 .
    Even though I created new JDBC provider and the classpath is pointing to the v10 jar files in the Admin console of WebSphere Application Server.
    still the logs are having the JDBC driver number as 3.59.81 which is v9.6 JDBC provder model
     

    [9/18/13 9:00:03:378 GMT] 0000002b SystemOut     O [AMT] [GWALogger] [2013-09-18 09:00:03,378] [DEBUG] Setting up a new datasource 
    [9/18/13 9:00:03:992 GMT] 0000002b PrivExAction  W   J2CA0144W: No mappingConfigAlias found for ConnectionFactory or DataSource jdbc/isc_tools_cf_aamt_aamtdbDS.
    [9/18/13 9:00:05:796 GMT] 0000002b InternalGener I   DSRA8203I: Database product name : DB2/AIX64
    [9/18/13 9:00:05:815 GMT] 0000002b InternalGener I   DSRA8204I: Database product version : SQL10012
    [9/18/13 9:00:05:818 GMT] 0000002b InternalGener I   DSRA8205I: JDBC driver name  : IBM DB2 JDBC Universal Driver Architecture
    [9/18/13 9:00:05:821 GMT] 0000002b InternalGener I   DSRA8206I: JDBC driver version  : 3.59.81
    [9/18/13 9:00:05:825 GMT] 0000002b InternalDB2Un I   DSRA8212I: DataStoreHelper name is: com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper@7a647a64.
    [9/18/13 9:00:05:830 GMT] 0000002b WSRdbDataSour I   DSRA8208I: JDBC driver type  : 4
     

    I guess it should have been changed to 3.65.77 ? 

  • frs
    frs
    4 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2014-10-26T00:15:49Z  
    I am posting to this thread because it is mentioned in IBM's list of JDBC driver versions (document reference 1363866). That document is actively maintained by IBM, and I reference it often, but it is missing an important piece of information that would greatly assist DB2 administrators.
     
    When a DBA obtains an application snapshot for a JDBC connection, the only identifying information the snapshot provides about the JDBC driver version is the "Client database manager product ID" ("JCC03000", for example). Assuming this string corresponds to a specific fix pack level of a DB2 JDBC driver and always varies by version, it would be a tremendous help to DBAs if the 1363866 technote included it, since obtaining any of the other attributes in that document require access to the JDBC driver JAR files, which are typically buried deep within an application server, or -even worse- an end user's workstation. When a DBA is trying to diagnose a troublesome connection, authoritatively identifying a JDBC driver's version from application snapshot data is considerably more practical than chasing down the actual JAR file.
     
    If the database client manager product ID string (client_prdid) for JCC connections indicated the JDBC driver version as intuitively as it does for CLI connections (where SQL09071 indicates v9.7 FP1) then it wouldn't be necessary to document all the JDBC driver strings somewhere, since a DBA could simply infer the JDBC driver version from the client_prdid element provided by the application snapshot. However, encountering a client_prdid such as JCC03000 (a real-world example) when the 1363866 technote shows no JDBC driver v3.0.0 exists demonstrates that it's not that straightforward.
     
    I hope IBM agrees with me and ultimately incorporates the client_prdid for each JDBC driver into technote 1363866, which will save me the effort of downloading every client fix pack on my own and building the list myself.
     
    Thanks,
    Fred
  • GertHelsen
    GertHelsen
    1 Post

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-06-17T10:39:18Z  

    I am looking for a JDBC driver that is compatible with native DLL version 4.15.120, but somehow all drivers I tried do not seem to be compatible.

    The highest version I can find on the driver download page is 4.15.113.

  • Slakshmi
    Slakshmi
    20 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-06-18T20:28:31Z  

    I am looking for a JDBC driver that is compatible with native DLL version 4.15.120, but somehow all drivers I tried do not seem to be compatible.

    The highest version I can find on the driver download page is 4.15.113.

    Hello,

       Could you please explain what is the native DLL you are looking compatible for?

    Thanks!

  • tom_1st
    tom_1st
    3 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-07-22T16:52:57Z  

    Hi,

     

    I have a question regarding those JDBC files: What is the license of those jars?

    We want to supply those drivers to our customers (which obviously have a running websphere) - are we allowed to do that?

     

    Thanks!

  • Slakshmi
    Slakshmi
    20 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-07-22T17:02:47Z  
    • tom_1st
    • ‏2015-07-22T16:52:57Z

    Hi,

     

    I have a question regarding those JDBC files: What is the license of those jars?

    We want to supply those drivers to our customers (which obviously have a running websphere) - are we allowed to do that?

     

    Thanks!

    Hi,

       If you are going to connect to DB2 on Host systems (DB2 on z/OS or DB2 on I/series) using that JCC driver, then you need the license jar db2jcc_license_cisuz.jar in the classpath.

    Information on how to get that license: http://www-01.ibm.com/support/docview.wss?uid=swg21413734

    If you are going to connect to DB2 on LUW, no license is required.

    JCC driver (db2jcc.jar or db2jcc4.jar) is stand alone and that needs to be added to WAS CLASSPATH to make a Type 4 Connection to DB2.

    Hope this answers your question.

    Thanks!

    Subbu Prabhu

     

  • tom_1st
    tom_1st
    3 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-07-22T17:34:01Z  
    • Slakshmi
    • ‏2015-07-22T17:02:47Z

    Hi,

       If you are going to connect to DB2 on Host systems (DB2 on z/OS or DB2 on I/series) using that JCC driver, then you need the license jar db2jcc_license_cisuz.jar in the classpath.

    Information on how to get that license: http://www-01.ibm.com/support/docview.wss?uid=swg21413734

    If you are going to connect to DB2 on LUW, no license is required.

    JCC driver (db2jcc.jar or db2jcc4.jar) is stand alone and that needs to be added to WAS CLASSPATH to make a Type 4 Connection to DB2.

    Hope this answers your question.

    Thanks!

    Subbu Prabhu

     

    Thanks for your answer but I think you misunderstood me: I don't meant the license file in form of a license key I meant the license in form of a copyright license like LGPL or Apache License or IBM Public License 1.0 (IPL).

     

    We don't want to connect to a DB2 DB in any way - we just distribute the jar files for convience sake to our customers which then use them to connect to their DB2 DB. And they of course own a license (key). So I ask again - what is the license of those classes?

  • mor
    mor
    577 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-07-22T17:42:44Z  
    • tom_1st
    • ‏2015-07-22T17:34:01Z

    Thanks for your answer but I think you misunderstood me: I don't meant the license file in form of a license key I meant the license in form of a copyright license like LGPL or Apache License or IBM Public License 1.0 (IPL).

     

    We don't want to connect to a DB2 DB in any way - we just distribute the jar files for convience sake to our customers which then use them to connect to their DB2 DB. And they of course own a license (key). So I ask again - what is the license of those classes?

    You might be asking about *redistribution* of a component like the DB2 runtime client. Check the docs for that. In previous versions at least (of DB2) IBM used to support that, if I recall correctly, but you would need to contact IBM (not via a Forum) after researching that to see what's involved. I know it is possible because some non-IBM companies re-distribute IBM's db2jcc4 driver for java applications but I don't know what's involved legally.

  • tom_1st
    tom_1st
    3 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-07-22T20:32:32Z  
    • mor
    • ‏2015-07-22T17:42:44Z

    You might be asking about *redistribution* of a component like the DB2 runtime client. Check the docs for that. In previous versions at least (of DB2) IBM used to support that, if I recall correctly, but you would need to contact IBM (not via a Forum) after researching that to see what's involved. I know it is possible because some non-IBM companies re-distribute IBM's db2jcc4 driver for java applications but I don't know what's involved legally.

    I did research this issue and normally for other libraries it is quite easy to find out the *redistribution* license - however for the DB2 JDBC drivers its seems quite hidden.

    1.) No mentioning of the license or any docs on the download page: http://www-01.ibm.com/support/docview.wss?uid=swg21363866

    2.) Normally it is a standard to put a license.txt or notice.txt or something similar inside the jar file however there is no license file within the JAR

    3.) Googleing 'db2jcc redistribution' or 'db2jcc license' did turn up nothing (only questions with answers which didn't help)

    4. ) Reading the docs to the downloads didn't help (http://publib.boulder.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.swg.im.dbclient.install.doc/doc/c0022612.html)

     

    So why is it so complicated to find out the redistribution/copyright license?

  • mor
    mor
    577 Posts

    Re: How do I find the right DB2 JDBC Driver?

    ‏2015-07-23T05:08:48Z  
    • tom_1st
    • ‏2015-07-22T20:32:32Z

    I did research this issue and normally for other libraries it is quite easy to find out the *redistribution* license - however for the DB2 JDBC drivers its seems quite hidden.

    1.) No mentioning of the license or any docs on the download page: http://www-01.ibm.com/support/docview.wss?uid=swg21363866

    2.) Normally it is a standard to put a license.txt or notice.txt or something similar inside the jar file however there is no license file within the JAR

    3.) Googleing 'db2jcc redistribution' or 'db2jcc license' did turn up nothing (only questions with answers which didn't help)

    4. ) Reading the docs to the downloads didn't help (http://publib.boulder.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.swg.im.dbclient.install.doc/doc/c0022612.html)

     

    So why is it so complicated to find out the redistribution/copyright license?

    "So why is it so complicated to find out the redistribution/copyright license? "

    That is the strange world of IBM. This kind of forum might not get you the answer you seek, because this forum tends to be used for technical problem solving matters, not legal matters. But you might also be lucky.