473,385 Members | 1,875 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

db2 connect required for accessing db2 on z/os?

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
2 3303
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: DAVID | last post by:
Hello, With regards to the Connect dialog on Oracle forms 6i via which we can connect to Oracle database, should we use the same functionality on forms run time again? I mean, I want to make a...
30
by: aka | last post by:
Hi I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect instance as tcpip node and then the Host DB...
3
by: Fabian Knopf | last post by:
Hi friends, i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) . Then i have another machine PC2 i installed there also ( IBM DB2 V8.1 ). On PC2 i installed unixODBC. To...
10
by: Ed Stevens | last post by:
A tale of woe, and a question . . . Last week my boss said to me "we've installed DB2 Connect on this Solaris box. Make it work." Now, I've barely seen DB2 Connect on Windows, having fumbled...
2
by: iwdu15 | last post by:
hey, i was wondering if 1) anyone could tell me whats wrong with my code, i did a little fixing to the msdn version fo this, or 2) how to make a simple program that will connect and listen for...
2
by: Mondal | last post by:
Hi, I am using MySQL 5.0 beta and Active Python 2.4. I have the correct version of MySQLdb installed. The problem is that I can't connect to MySQL through the Active Python interactive window. ...
0
by: vikas.bhatia | last post by:
Is this still true? http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/58c6c36ce9006d50/778f98749d8e2983?lnk=st&q=DB2+Connect+product+license&rnum=6#778f98749d8e2983 would...
3
by: =?Utf-8?B?Ulc=?= | last post by:
Using this code: Dim oConn As SqlClient.SqlConnection oConn = New SqlClient.SqlConnection() oConn.ConnectionString = "..." 'Connection string I got via an .udl file oConn.Open() I get an...
6
by: Al G | last post by:
Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from files on our AS400. I've downloaded DB2, and...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.