By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

db2 connect required for accessing db2 on z/os?

P: n/a
Is this still true?
http://groups.google.com/group/comp....8f98749d8e2983

would a standard type 4 driver, jar file copy into the WEB-INF/lib
folder not work?

I am trying to access db2 8 on z/os though a java app server.

thanks.

V.

May 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
vi**********@gmail.com wrote:
Is this still true?
http://groups.google.com/group/comp....8f98749d8e2983

would a standard type 4 driver, jar file copy into the WEB-INF/lib
folder not work?

I am trying to access db2 8 on z/os though a java app server.


Excerpt from http://tinyurl.com/s4gce [ibm.com]:

Q: "My understanding is that DB2 Version 8.1 ships a Java client
(Type 4 JDBC driver), which has DRDA function built into it and
therefore does not need a DB2 client or DB2 Connect. Does this mean that
I will no longer need DB2 Connect to access my host data source if I
use a Type 4 JDBC driver?"

A: "You must license access by any means for distributed clients to
zSeries- and iSeries-based versions of DB2. The JDBC drivers shipped
with DB2 Version 8.1 may be used for connecting to a properly licensed
DB2 databases on a Linux, UNIX, or Windows servers only without DB2
Connect. These JDBC drivers are not licensed for use with DB2 for z/OS
and DB2 for i5/OS database servers without DB2 Connect – again, you must
purchase an appropriate DB2 Connect product. You should be aware that a
Type 4 JDBC driver will give you access to DB2 host and mainframe data
through the JDBC or SQLJ API, but that's it. DB2 Connect is a middleware
product that is far more than a ‘bag’ of drivers. DB2 Connect offers
support for the following APIs: ODBC, JDBC, SQLJ, DB2 CLI, ADO, ADO.NET,
and embedded SQL. DB2 Connect also gives users transparent access
through heterogeneous joins across the DB2 family, Informix IDS; access
to mainframe resources like CICS, VSAM, and IMS are easily exposed
through stored procedures; a connection concentrator to maximize
mainframe usage; automatic client reroute for transparent failover,
complete application development support including the DB2 Development
Center and plug-ins for the world’s most popular IDEs, a mobile database
with a complete synchronization architecture, a heath monitoring
system, and more."
May 3 '06 #2

P: n/a
vi**********@gmail.com wrote:
Is this still true?
http://groups.google.com/group/comp....8f98749d8e2983

would a standard type 4 driver, jar file copy into the WEB-INF/lib
folder not work?

I am trying to access db2 8 on z/os though a java app server.

thanks.

V.

I'm not sure that I can entirely answer your question. I CAN tell you
that the type-4 driver that comes with DB2 Connect will allow you to
connect directly to DB2 on z/OS. However, I believe that you must
license DB2 Connect ... even if you are only using the type-4 driver.

Larry Edelstein
May 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.