Need to check the JDBC driver version while doing DB2 for z/OS upgrade

JITINDER CHOUDHARY

Need to check the JDBC driver version while doing DB2 for z/OS upgrade

Hi All,

To check the version of jdbc driver we need to give the command 'java com.ibm.db2.jcc.DB2Jcc –version' But I am not getting where and how to give this comand. 

If any one having any idea. Please suggest how to use the above command to check the JDBC driver version.

Thanks everyone in Advance!!!!

Lizette Koehler

Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to JITINDER CHOUDHARY)
The following command will retrieve the JCC driver version if executed from the command line:

java com.ibm.db2.jcc.DB2Jcc -version


Or for drivers that are not yet installed:

java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version



Where are you entering the command? Do you get anything back? If so, what are the messages



An internet search on the command will provide more hits and answers





Lizette





From: JITINDER CHOUDHARY [mailto:[login to unmask email]
Sent: Wednesday, July 12, 2017 8:14 AM
To: [login to unmask email]
Subject: [DB2-L] - Need to check the JDBC driver version while doing DB2 for z/OS upgrade



Hi All,

To check the version of jdbc driver we need to give the command 'java com.ibm.db2.jcc.DB2Jcc –version' But I am not getting where and how to give this comand.

If any one having any idea. Please suggest how to use the above command to check the JDBC driver version.

Thanks everyone in Advance!!!!



-----End Original Message-----

George Palko

Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to Lizette Koehler)
You’d want to enter those commands via OMVS. Type TSO OMVS on the command line. Make sure your .profile is set up with the correct class paths.

From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, July 12, 2017 11:46 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade

The following command will retrieve the JCC driver version if executed from the command line:
java com.ibm.db2.jcc.DB2Jcc -version

Or for drivers that are not yet installed:
java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version

Where are you entering the command? Do you get anything back? If so, what are the messages

An internet search on the command will provide more hits and answers


Lizette


From: JITINDER CHOUDHARY [mailto:[login to unmask email]
Sent: Wednesday, July 12, 2017 8:14 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Need to check the JDBC driver version while doing DB2 for z/OS upgrade


Hi All,

To check the version of jdbc driver we need to give the command 'java com.ibm.db2.jcc.DB2Jcc –version' But I am not getting where and how to give this comand.

If any one having any idea. Please suggest how to use the above command to check the JDBC driver version.

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

JITINDER CHOUDHARY

RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to George Palko)

Hi George,

Thanks for you quick responce!!!!

I am giving the below command in OMVS.

java com.ibm.db2.jcc.DB2Jcc -11.

But not able to get the jdbc version. Please suggest if i am doing something wrong. 

Your quick response is much appreciated.

Lizette Koehler

Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to JITINDER CHOUDHARY)
1)  Where are you entering the command?
2)  What do you get when you enter the command
3)  Are there any messages in SYSLOG at the time you enter the command.

Lizette

-----Original Message-----
From: JITINDER CHOUDHARY
Sent: Jul 12, 2017 10:27 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade


Hi George,
Thanks for you quick responce!!!!
I am giving the below command in OMVS.
java com.ibm.db2.jcc.DB2Jcc -11.
But not able to get the jdbc version. Please suggest if i am doing something wrong. 
Your quick response is much appreciated.
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

Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to Lizette Koehler)
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:

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: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, July 12, 2017 2:24 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade

1) Where are you entering the command?
2) What do you get when you enter the command
3) Are there any messages in SYSLOG at the time you enter the command.

Lizette
-----Original Message-----
From: JITINDER CHOUDHARY
Sent: Jul 12, 2017 10:27 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade

Hi George,

Thanks for you quick responce!!!!

I am giving the below command in OMVS.

java com.ibm.db2.jcc.DB2Jcc -11.

But not able to get the jdbc version. Please suggest if i am doing something wrong.

Your quick response is much appreciated.

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

J&#248;rn Thyssen

RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to JITINDER CHOUDHARY)

Hi,

You should issue the commands on all the clients you wish to check. This can be distributed servers, e.g.,  running Websphere or other application servers; personal workstations running IBM Data Studio, QMF, Excel, or other programs connecting to Db2; or it can be USS/OMVS if you run Java under CICS, Liberty z/OS or Websphere for z/OS.

 

Alternatively, you can in some cases find the driver versions using Db2 accounting data. 

 

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. 

JITINDER CHOUDHARY

RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to George Palko)

Thanks George!!

I am giving the command OMVS but its saying invalid command.

Could you please give me exact command that we need to give. How to give the version at the end. We need to give the version in single quote or double quote.

Please suggest.

Chad Walmer

Need to check the JDBC driver version while doing DB2 for z/OS upgrade
(in response to JITINDER CHOUDHARY)
Jitinder,
I don’t see that anyone got back to you on this yet. The “-version” at the end of the command is not referring to the DB2 version you are running. It should be entered exactly as George listed it in his email and it’s instructing the JCC driver to list what version it is running.

Also, George’s detailed email should help you with your other post where you are getting a mismatch between the JCC driver and the native DLL. I agree with George that it appears you have an older version of the OMVS code since the driver version is older than the native DLL. Basically the code in OMVS must be at the same level as that in SDSNLOD2 (native). Check your OMVS profile to ensure you are pointed to the correct JCC locations (LIBPATH, JCC_HOME, and STEPLIB.) Either you are still pointing to the V10 libraries (hopefully it’s obvious from the path names) or maintenance was applied to the V11 code and the OMVS side was not refreshed.

Chad Walmer

From: JITINDER CHOUDHARY [mailto:[login to unmask email]
Sent: Thursday, July 13, 2017 5:53 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Need to check the JDBC driver version while doing DB2 for z/OS upgrade


Thanks George!!

I am giving the command OMVS but its saying invalid command.

Could you please give me exact command that we need to give. How to give the version at the end. We need to give the version in single quote or double quote.

Please suggest.

-----End Original Message-----