JDBC driver for mainframe DB2

JITINDER CHOUDHARY

JDBC driver for mainframe DB2

Hi All,

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 !!!!

Jitinder C 

Lizette Koehler

JDBC driver for mainframe DB2
(in response to JITINDER CHOUDHARY)
I would suspect it is part of the pre-work before you can begin to rollout V11.



How does your shop roll out updates to PCs and Servers? That is the group you will need to engage as part of your project.



Ensure your JAVA on the mainframe is also compatible. That would be your z/OS System Programmer group.



1. Identify all PCs or Servers running on lower versions of JDBC
2. Upgrade all PCs or Servers running on loser versions of JDBC
3. Validate users can still run with current software levels after updating the JDBC



From what I have seen with past migrations for DB2, if the JDBC is not upgraded before the DB2 Version, then your users are going to have issues with functions they use in DB2



For example, I recently installed a product on the mainframe where I had a lot of users not be able to use the Client for this product due to their level on their PC for JAVA was 1.5 – so we had to engage the team that does software roll out /deployment to PCs to upgrade them to 1.8





Lizette







From: JITINDER CHOUDHARY [mailto:[login to unmask email]
Sent: Monday, October 16, 2017 6:11 AM
To: [login to unmask email]
Subject: [DB2-L] - JDBC driver for mainframe DB2



Hi All,

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 !!!!

Jitinder C



Charles Brown

JDBC driver for mainframe DB2
(in response to JITINDER CHOUDHARY)
Jitinder,
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

Charles
NZ DBA

Sent from my iPad

> On Oct 16, 2017, at 8:10 AM, JITINDER CHOUDHARY <[login to unmask email]> wrote:
>
> Hi All,
>
> 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 !!!!
>
> Jitinder C
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
> ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
> http://www.ESAIGroup.com/idug
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

George Palko

JDBC driver for mainframe DB2
(in response to Charles Brown)
Jitinder,

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 WAS.

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:

export _BPXK_AUTOCVT=ON
export UMASK=o+r
export PATH=/etc/java/bin:/usr/lpp/db2/base/bin::/usr/lpp/db2/base/lib:/u/tbcs:$PATH
export JAVA_HOME=/etc/java/bin
export CLASSPATH=/etc/java:$CLASSPATH
export CLASSPATH=/usr/lpp/db2/jdbc/classes/db2jcc4.jar:$CLASSPATH
export CLASSPATH=/usr/lpp/db2/jdbc/classes/db2jcc_license_cisuz.jar:$CLASSPATH
export CLASSPATH=/usr/lpp/db2/base/classes/db2javasp.jar:$CLASSPATH
export THBPATH=$LIBPATH:/usr/lpp/db2/base/lib
export STEPLIB='TECH.DSNB10.SDSNLOAD':'TECH.DSNB10.SDSNLOD2'
#export TZ="EST0EDT0"


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.

cd /usr/lpp/db2/jdbc/bin/

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.
George


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

Jitinder,
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

Charles
NZ DBA

Sent from my iPad

On Oct 16, 2017, at 8:10 AM, JITINDER CHOUDHARY <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi All,

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 !!!!

Jitinder C

-----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 e-mail.