Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 for z/OS forum  >  developerWorks

jdbc connection from wondows to Z/OS    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 1 - Pages: 1 - Last Post: Oct 26, 2009 4:05 AM Last Post By: momi
faisalbhagat

Posts: 2
Registered: Jul 16, 2009 05:25:00 AM
jdbc connection from wondows to Z/OS
Posted: Oct 25, 2009 04:21:10 PM
 
Click to report abuse...   Click to reply to this thread Reply
hi guys!
i am an absolute new in the world of Z/OS. my development machine is windows and IBM websphere is installed on it. i have been given a TestDB DB2 installed on Z/OS. i have to test my DAO's with this DB. is it possible to create a datasource in WAS for this DB on Z/OS while WAS is on windows? if yes any special jdbc driver required? if required from where i can get?. Any answer in this regard will be highly appreciated. i have to complete this task in two days :-<.

regards
momi

Posts: 86
Registered: Jan 07, 2007 10:49:29 AM
Re: jdbc connection from wondows to Z/OS
Posted: Oct 26, 2009 04:05:13 AM   in response to: faisalbhagat in response to: faisalbhagat's post
 
Click to report abuse...   Click to reply to this thread Reply
Hi
Welcome to the DB2 world...

It is possible to connect a windows was to a zos db2,
actually, the db2 jdcb universal driver can be used for any combination of db2 platforms,
the driver resides in
db2jcc.jar

before you can connect, you need another jar called
db2jcc_license_cu.jar

this jar comes by default and allows you to connect to db2 luw and cloudspace
in order to connect to zos you will need a jar file called
db2jcc_license_cisuz.jar

i guess you got it with the webshpere installation so just look for it
once these two files are in the class path, you should be able to configure a datasource in was in no time

good luck!
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums