From my experience migrating to v11, we had to upgrade the driver
residing on the mainframe to 4.19.66 so that our WAS applications
would work correctly. We did not upgrade db2 connect.
There is an APAR/PTF JCCV41966/PI59547 that is available. Simply
download and apply via shopZ. One thing to keep in mind is that
there are two db2jcc.jar files. Make sure you tell the developers
to use the db2jcc4.jar file and not the old db2jcc.jar file.
User’s can point to /usr/lpp/db2/jdbc/classes/db2jcc4.jar or
they can migrate the jar file over to their system i.e. z/Linux
Here’s some other info that will help in verifying that you
have the correct driver installed:
First, make sure you have an OMVS profile setup. Get with your
Security team to set one up if you don’t. You’ll also
need a .profile set up within USS. It might look like this:
Secondly, when you go into OMVS you’ll want to change the
directory to the jdbc binary path something like this. Your path
might be different. This is just standard IBM default paths.
Once you do that enter this command:
java com.ibm.db2.jcc.DB2Jcc -version
You should see something like this which verifies that the you have
the right driver installed.
IBM Data Server Driver for JDBC and SQLJ 4.19.66
Make sure you have the OMVS profile setup in RACF along with the
user .profile set up in the /u USS path.
Hope this helps.
From: Charles Brown [mailto:[login to unmask email]
Sent: Tuesday, October 17, 2017 5:18 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: JDBC driver for mainframe DB2
Hope all is well. BTW - good question.
Because the driver provides application connectivity to db2, as
stated on the subject line then the driver can be considered a db2
enabling product. Hope you see where I'm going with this?
Furthermore, chances are the driver could've been bundled with db2
Connect (data server products)- right? If it was then Bam! Which
team supports db2 Connect -- db2 DBA? In most shops, the db2 DBA
owns the connectivity products. Your thoughts?
Hope this helps
Sent from my iPad
On Oct 16, 2017, at 8:10 AM, JITINDER CHOUDHARY
<[login to unmask email]<mailto:[login to unmask email]>>
Currently we are using JDBC driver 3.9 for DB2 v10.1 for z/OS. Now
we are migrating our DB2 v10.1 to DB2 v11 for that we need JDBC
driver 4.1. As JDBC driver 3.9 is not suitable for DB2 v11.
Could you please let us know migrating JDBC driver from version 3.9
to 4.1 is a part of DB2 team if, not please let us know which team
will take care of this part.
Thanks in Advance !!!!
-----End Original Message-----
-----End Original Message-----
CONFIDENTIALITY NOTICE: The Ohio Public Employees Retirement System
intends this e-mail message, and any attachments, to be used only
by the person(s) or entity to which it is addressed. This message
may contain confidential and/or legally privileged information. If
the reader is not the intended recipient of this message or an
employee or agent responsible for delivering the message to the
intended recipient, you are hereby notified that you are prohibited
from printing, copying, storing, disseminating or distributing this
communication. If you received this communication in error, please
delete it from your computer and notify the sender by reply