Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

How can I determine the type 4 jcc driver installed?

  • 1.  How can I determine the type 4 jcc driver installed?

    Posted Thu August 13, 2020 02:12 PM

    How can I determine the type 4 jcc driver installed?





    #Db2
    #Db2forLUW
    #Support
    #SupportMigration


  • 2.  RE: How can I determine the type 4 jcc driver installed?

    Posted Thu August 13, 2020 06:26 PM

    Have you tried using the db2level command to find where it is installed, then see if your system is configured to use the db2jcc4.jar file, which is the type 4 driver.


    https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.admin.cmd.doc/doc/r0009195.html





    #Db2
    #Db2forLUW
    #Support
    #SupportMigration


  • 3.  RE: How can I determine the type 4 jcc driver installed?

    Posted Thu August 13, 2020 07:25 PM

    I know the version of DB2 being used (v11.1.4.4), and where it is installed, but I don't know how to tell what is the version of the db2jcc4.jar. I also know there is a webpage in IBM (https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads) that indicates what jcc drivers are supposed to be installed for each version of DB2, but I am trying to find out what command to run that displays the version of a type 4 driver. This command displays the type 3 driver "java com.ibm.db2.jcc.DB2Jcc -version", but I don't know the command for type 4.





    #Db2
    #Db2forLUW
    #Support
    #SupportMigration