If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > JDBC driver for [WAS on AIX] to connect to [DB2 on zOS]

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
JDBC driver for [WAS on AIX] to connect to [DB2 on zOS]

I think this is more of a WAS question, but I hope someone here can answer it.

What we have is:
WAS (WebSphere Application Server) running on AIX - connect to - DB2 z/OS. There is no DB2 LUW in the picture (except for the DB2 Connect license file).

WAS on AIX + DB2 Universal JDBC Driver + DB2 Connect license file -> DB2 z/OS


I know DB2 Universal JDBC Driver can be downloaded from IBM DB2 JDBC Driver Versions - United States . But this is DB2 LUW specific site and the driver version listed there correspond to DB2 LUW release/fixpack level.


I found the following info:

WAS -> WebSphere Application Server Version 7.0
DB2 z/OS -> IBM Information Management Software for z/OS Solutions Information Center


What I'm not clear about is where people who manage WAS should download JDBC driver from? Both links listed under the NOTES section here
IBM DB2 JDBC Driver Versions - United States take me to DB2 LUW specific sites. I told WAS people to get the driver from this site, but I was wondering if they can get it from some other download site that is not LUW specific.

Could some please clarify?

Last edited by db2girl; 11-22-12 at 22:08.
Reply With Quote
  #2 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
I've done some additional reading and came to the conclusion that DB2 LUW download site is the only place to get DB2 Universal JDBC driver if the client application (WAS in my example) is on AIX => the platform of JDBC driver and WAS have to match. Now, I need to convince other DBA's that it's not our responsibility to download / upgrade this driver (even if we get it from DB2 LUW download site).

I'd like to get an opinion from other people re: whose job is it to install/maintain this JDBC driver - DBA or application that uses it?
Reply With Quote
  #3 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,375
Quote:
Originally Posted by db2girl View Post
whose job is it to install/maintain this JDBC driver - DBA or application that uses it?
I guess it's whoever's arse will be kicked if it's not installed.
__________________
---
"It does not work" is not a valid problem statement.
Reply With Quote
  #4 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
Quote:
Originally Posted by n_i View Post
I guess it's whoever's arse will be kicked if it's not installed.
Whoever needs it and have access to install and knowledge to configure -->> apps.

zOS DBA can review WAS config parameters to ensure they're set appropriate for their zOS env. I don't see why LUW DBA needs to be involved here... all I can do is suggest to upgrade to stay current and download it for them. If this was DB2 Connect product and not just the driver, then of course.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 746
As I understand:
In the good-old-days we needed a JDBC type2 driver
- so we needed db2-client software to be installed on the WAS machine
- so we needed a db2 connect instance somewhere in our network to guide us to the mainframe (or AS400 a.k.a. system i). All part of the LUW product line.
Today (with the modern WAS versions) we only need a JDBC type4 driver to access the mainframe directly. No other db2/luw thingies required.

A different playing field for us LUW DBA's...even worse: they kicked is out.... they don't need us anymore
__________________
Somewhere between " too small" and " too large" lies the size that is just right.
- Scott Hayes
Reply With Quote
  #6 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
Based on my understanding, JDBC type4 driver is still part of DB2 LUW product line if WAS runs on LUW. But we, LUW DBA's, don't install / configure it. Like you said, they don't need us anymore (I think they still need zOS DBA somewhat). So, quoting n_i, my arse should not get kicked... or I will kick back and hard.

But I will have a very hard time convincing my team lead (who looks after LUW and zOS DBA's) that LUW DBA should not be involved here.
Reply With Quote
  #7 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
Quote:
Originally Posted by db2girl View Post
What we have is:
WAS (WebSphere Application Server) running on AIX - connect to - DB2 z/OS. There is no DB2 LUW in the picture (except for the DB2 Connect license file).

WAS on AIX + DB2 Universal JDBC Driver + DB2 Connect license file -> DB2 z/OS
We're planning to purchase: DB2 Connect Unlimited Edition (System z)

As per IBM Knowledge Center , the db2connectactivate utility can be used to activate the license on DB2 z/OS server.

This utility has to be run from DB2 LUW. If we don't have any DB2 LUW installed and just have DB2 z/OS and WAS servers, what can we do? Have to install LUW just to activate license? Anything needs to be done on WAS servers to make them aware of this new license? Has anyone done this before?
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Jul 2013
Location: Moscow, Russia
Posts: 204
db2connectactivate is a standalone utility.
You can download it from the Passport Advantage site.
For example, for DB2 Version 9.7 Activation key part numbers it's P/N CI36DML.
__________________
Regards,
Mark.
Reply With Quote
  #9 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
Where do I execute db2connectactivate from?
Reply With Quote
  #10 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,375
From any machine with Java, the JDBC driver, and connectivity to the host, would be my guess. The WAS server looks like a good candidate.
__________________
---
"It does not work" is not a valid problem statement.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On