473,836 Members | 1,506 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3336
Ian
vi**********@gm ail.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**********@gm ail.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
4824
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 window with three screen items for username, password and service name. And on run time after connecting to the database I use this window to reconnect to an other database. So when I give the appropriate information, I will connect to the
30
7455
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 cataloged on that node...this works from v7.2 Fixpack 11 clients and servers, but with v8.1 server I get SQL1334N. Does anyone has an idea? Thanks
3
5747
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 connect to the database over ODBC on unix i did this: on db2 console: catalog tcpip node archiv remote PC1 server DB2_db2inst1
10
4382
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 thru one install and config, with a lot of handholding from IBM Support. I'm comfortable in unix but have never dealt with DB2 Connect there. (my main job is as an Oracle DBA, and most of my db's are on Solaris or AIX) I've found the install...
2
1877
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 connections async. if the user pushes the selected buttons. i just want a program that connects to another computer on the port and IP address selected and if the other computer is listening, then connect to it but this code doesnt work : Imports...
2
4518
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. Here is a sample error: >>> c=MySQLdb.Connect(host='localhost',user='root',passwd='',db='shop',port=3306) Traceback (most recent call last):
0
344
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 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.
3
2130
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 error here: Request for the permission of type System.Data.SqlClientPermission,
6
4608
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 installed it, but apparently I need an additional product, "DB Connect" to actually make a connection. "DB connect" says that it will only display tables with a type of "T", and as far as I know, we are using files, not tables on the 400. Can...
0
9826
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9674
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10860
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10560
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10604
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10261
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9389
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5659
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4026
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.