DB2 V11 z/OS Migration and JDBC

Mike Martin

DB2 V11 z/OS Migration and JDBC
Hi all,

We are about to migrate DB2 z/OS V10 to V11. We have a couple remote server (Linux on z) applications that come in using DDF with the TYPE 4 JDBC driver.

Do we need to update the servers with the new files that came with V11? Or should the old ones work?

db2jcc_license_cisuz.jar
db2jcc4.jar

Mike Martin
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

Philip Sevetson

DB2 V11 z/OS Migration and JDBC
(in response to Mike Martin)
**please note my email address change**
We just migrated our Websphere drivers from falling-off-the-back-end-of-support JDBC type 3's to current-bleeding-edge JDBC type 4s. This was successful for us, and as far as I know did not require recoding of the requesting applications. Hope that helps...

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Monday, August 14, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2 V11 z/OS Migration and JDBC

Hi all,

We are about to migrate DB2 z/OS V10 to V11. We have a couple remote server (Linux on z) applications that come in using DDF with the TYPE 4 JDBC driver.

Do we need to update the servers with the new files that came with V11? Or should the old ones work?

db2jcc_license_cisuz.jar
db2jcc4.jar

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Kirk Hampton

DB2 V11 z/OS Migration and JDBC
(in response to Philip Sevetson)
I have always lacked a full understanding of the JDBC drivers.
When you have a remote JDBC application such as Mike's,
are the .jar files in z/OS under OMVS for the local z/OS DB2 being used,
or don't the .jar files have to be copied to the originating remote server where the app is running ?

Thanks,

J. Kirk Hampton
DB2 z/OS Sysprog
HCL America
Frisco, Texas
817-228-6083


From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Monday, August 14, 2017 9:17 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: DB2 V11 z/OS Migration and JDBC

**please note my email address change**
We just migrated our Websphere drivers from falling-off-the-back-end-of-support JDBC type 3's to current-bleeding-edge JDBC type 4s. This was successful for us, and as far as I know did not require recoding of the requesting applications. Hope that helps...

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Monday, August 14, 2017 10:08 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2 V11 z/OS Migration and JDBC

Hi all,

We are about to migrate DB2 z/OS V10 to V11. We have a couple remote server (Linux on z) applications that come in using DDF with the TYPE 4 JDBC driver.

Do we need to update the servers with the new files that came with V11? Or should the old ones work?

db2jcc_license_cisuz.jar
db2jcc4.jar

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

J&#248;rn Thyssen

RE: DB2 V11 z/OS Migration and JDBC
(in response to Mike Martin)

Hi Mike,

You can download the newest version of db2jcc4.jar here -- choose the appropriate version of DB2 Connect first and then "IBM Data Server Driver for JDBC and SQLJ": It is a light-weight package containing the JAR files only.

http://www-01.ibm.com/support/docview.wss?uid=swg27016878

If don't think you need a new db2jcc_license_cisuz.jar, but if you do, it is downloaded from IBM Passport Advantage.

If you have the unlimited enterprise edition, I suggest you install the license at z/OS side, so you don't have to think about licensing on the client side.

The JAR files that is supplied with DB2 for z/OS itself is generally for JDBC applications on z/OS, e.g., Java applications running under USS, Liberty for z/OS, WAS for z/OS, or CICS.

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Philip Sevetson

DB2 V11 z/OS Migration and JDBC
(in response to Kirk Hampton)
**please note my email address change**

1) In the abstract, I don't know.

2) For Websphere, I believe it's executables which modify DB2 Connect config files. Which isn't an answer, sorry.

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: James Hampton, HCL America [mailto:[login to unmask email]
Sent: Monday, August 14, 2017 11:47 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 V11 z/OS Migration and JDBC

I have always lacked a full understanding of the JDBC drivers.
When you have a remote JDBC application such as Mike's,
are the .jar files in z/OS under OMVS for the local z/OS DB2 being used,
or don't the .jar files have to be copied to the originating remote server where the app is running ?

Thanks,

J. Kirk Hampton
DB2 z/OS Sysprog
HCL America
Frisco, Texas
817-228-6083


From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Monday, August 14, 2017 9:17 AM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - RE: DB2 V11 z/OS Migration and JDBC

**please note my email address change**
We just migrated our Websphere drivers from falling-off-the-back-end-of-support JDBC type 3's to current-bleeding-edge JDBC type 4s. This was successful for us, and as far as I know did not require recoding of the requesting applications. Hope that helps...

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Monday, August 14, 2017 10:08 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 V11 z/OS Migration and JDBC

Hi all,

We are about to migrate DB2 z/OS V10 to V11. We have a couple remote server (Linux on z) applications that come in using DDF with the TYPE 4 JDBC driver.

Do we need to update the servers with the new files that came with V11? Or should the old ones work?

db2jcc_license_cisuz.jar
db2jcc4.jar

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

J&#248;rn Thyssen

RE: DB2 V11 z/OS Migration and JDBC
(in response to Kirk Hampton)

Hi Kirk,

The jar files delivered with DB2 for z/OS itself are normally used for applications running on z/OS, but as JAR files are (in theory) portable, so you could copy them to a server. The jar files supplied with DB2 are updated through PTFs. You can find your driver level by issuing "cd /usr/lpp/db2/db2c10/classes" (db2b10 for V11, db2a10 for V10) and then "java -cp db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version". You can cross-reference the driver level with DB2 Connect version here: http://www-01.ibm.com/support/docview.wss?uid=swg21363866

Note that while no license is required for connecting to DB2 for z/OS from z/OS itself, you do need a license for DB2 Connect in order to connect from a remote application to DB2 for z/OS, so check with you software license department before you copy the files to one thousand servers ;)

Alternatively download the drivers from http://www-01.ibm.com/support/docview.wss?uid=swg27016878 and the license files from IBM Passport Advantage.

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Mike Martin

DB2 V11 z/OS Migration and JDBC
(in response to Jørn Thyssen)
Thanks Jørn,

Very good information. We have used the JAR files that are included in z/OS (/usr/lpp/db2a10/jdbc/classes/) without any problems.

I am still wondering if we can use the V10.1 driver after we migrate to V11 DB2.

Mike Martin

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Monday, August 14, 2017 12:52 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 V11 z/OS Migration and JDBC


Hi Mike,

You can download the newest version of db2jcc4.jar here -- choose the appropriate version of DB2 Connect first and then "IBM Data Server Driver for JDBC and SQLJ": It is a light-weight package containing the JAR files only.

http://www-01.ibm.com/support/docview.wss?uid=swg27016878

If don't think you need a new db2jcc_license_cisuz.jar, but if you do, it is downloaded from IBM Passport Advantage.

If you have the unlimited enterprise edition, I suggest you install the license at z/OS side, so you don't have to think about licensing on the client side.

The JAR files that is supplied with DB2 for z/OS itself is generally for JDBC applications on z/OS, e.g., Java applications running under USS, Liberty for z/OS, WAS for z/OS, or CICS.

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

Views are personal.

-----End Original Message-----
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

J&#248;rn Thyssen

RE: DB2 V11 z/OS Migration and JDBC
(in response to Mike Martin)

Hi Mike,

Any version of JDBC drivers that are in service can be used to connect to DB2 for z/OS. However, you cannot exploit V11 features until a certain level of the JDBC drivers. At the GA time in 2014 the minimum level for exploitation was V10.5 FP2 (driver version 3.67.26), but that has probably changed since then.

If you copied the jar files from DB2 10 at in 2010 I would strongly suggest upgrading them :)

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal.