Hi, and thanks in advance. I am reading documentation for
a JDBC driver which uses DRDA to talk to DB2, but seems
to imply that some DB2 installations/configurations might
make DRDA access optional.
Joe Weinstein at BEA Systems
8  2092 
Sorry for the duplicate post. I was having trouble with one of the
netscape newsreader, and didn't think it went through.
Joe
Joe ... can you explain what you are trying to accomplish? I'm not sure
I understand your question. Of course it is possible to run DB2 on z/OS
without DRDA access. But what exactly are you trying to accomplish
application-wise that might or might not require DRDA?
Larry Edelstein jo***********@g mail.com wrote:
Hi, and thanks in advance. I am reading documentation for
a JDBC driver which uses DRDA to talk to DB2, but seems
to imply that some DB2 installations/configurations might
make DRDA access optional.
Joe Weinstein at BEA Systems
Larry wrote:
Joe ... can you explain what you are trying to accomplish? I'm not sure
I understand your question. Of course it is possible to run DB2 on z/OS
without DRDA access. But what exactly are you trying to accomplish
application-wise that might or might not require DRDA?
Hi Larry, and thanks. The JDBC driver will only talk via DRDA, so I
wanted
to verify that in order to use the driver with a given z/OS DB2
instance,
that the DBMS needs to be configured to accept client connections that
speak DRDA, and that is optional, and may even be a separate purchase
item (DRDA access).
Joe
Joe ... I'm still not sure I understand what you are trying to
accomplish. Are you trying to access DB2 on z/OS via a Java type-4
driver from a client that resides on Windows/Linux/UNIX? If that is the
case, then if you want to do it with the IBM Java type-4 driver, this
requires licensing of DB2 Connect and use of DRDA.
As far as the mainframe and z/OS are concerned, everything you need for
DRDA is included with DB2 (and TCP/IP). You can find the enablement of
DRDA in the DB2 for z/OS pubs (including enablement of the DDF address
space).
It is only if you want to access DB2 for z/OS from OFF the z/OS platform
(normally from Windows/Linux/UNIX) that you need to purchase DB2 Connect.
Larry Edelstein jo***********@g mail.com wrote:
Larry wrote:
>>Joe ... can you explain what you are trying to accomplish? I'm not sure
I understand your question. Of course it is possible to run DB2 on z/OS
without DRDA access. But what exactly are you trying to accomplish
application-wise that might or might not require DRDA?
Hi Larry, and thanks. The JDBC driver will only talk via DRDA, so I
wanted
to verify that in order to use the driver with a given z/OS DB2
instance,
that the DBMS needs to be configured to accept client connections that
speak DRDA, and that is optional, and may even be a separate purchase
item (DRDA access).
Joe
Larry wrote:
Joe ... I'm still not sure I understand what you are trying to
accomplish. Are you trying to access DB2 on z/OS via a Java type-4
driver from a client that resides on Windows/Linux/UNIX? If that is the
case, then if you want to do it with the IBM Java type-4 driver, this
requires licensing of DB2 Connect and use of DRDA.
As far as the mainframe and z/OS are concerned, everything you need for
DRDA is included with DB2 (and TCP/IP). You can find the enablement of
DRDA in the DB2 for z/OS pubs (including enablement of the DDF address
space).
It is only if you want to access DB2 for z/OS from OFF the z/OS platform
(normally from Windows/Linux/UNIX) that you need to purchase DB2 Connect.
Larry Edelstein
Much appreciated. Yes the client will be on Windows or any other
non-IBM box. The driver I am investigating is a 3rd party one, and
needs nothing else on the client end. I was just making sure that
the use of that type-4 driver did not require anything extra on the
DBMS end.
Joe Weinstein at BEA Systems
Joe ... you will need to check with your type-4 driver vendor to find
out how their driver connects to DB2 for z/OS (if at all). If it is a
basic JDBC driver without any special DB2 for z/OS connectivity that is
provided by that vendor, then I believe you will have to use DB2 Connect
(DRDA).
Larry Edelstein jo***********@g mail.com wrote:
Larry wrote:
>>Joe ... I'm still not sure I understand what you are trying to
accomplish. Are you trying to access DB2 on z/OS via a Java type-4
driver from a client that resides on Windows/Linux/UNIX? If that is the
case, then if you want to do it with the IBM Java type-4 driver, this
requires licensing of DB2 Connect and use of DRDA.
As far as the mainframe and z/OS are concerned, everything you need for
DRDA is included with DB2 (and TCP/IP). You can find the enablement of
DRDA in the DB2 for z/OS pubs (including enablement of the DDF address
space).
It is only if you want to access DB2 for z/OS from OFF the z/OS platform
(normally from Windows/Linux/UNIX) that you need to purchase DB2 Connect.
Larry Edelstein
Much appreciated. Yes the client will be on Windows or any other
non-IBM box. The driver I am investigating is a 3rd party one, and
needs nothing else on the client end. I was just making sure that
the use of that type-4 driver did not require anything extra on the
DBMS end.
Joe Weinstein at BEA Systems
type 4 driver still need IBM licence.
Larry wrote:
Joe ... you will need to check with your type-4 driver vendor to find
out how their driver connects to DB2 for z/OS (if at all). If it is a
basic JDBC driver without any special DB2 for z/OS connectivity that is
provided by that vendor, then I believe you will have to use DB2 Connect
(DRDA).
Larry Edelstein
jo***********@g mail.com wrote:
Larry wrote:
>Joe ... I'm still not sure I understand what you are trying to
accomplish. Are you trying to access DB2 on z/OS via a Java type-4
driver from a client that resides on Windows/Linux/UNIX? If that is the
case, then if you want to do it with the IBM Java type-4 driver, this
requires licensing of DB2 Connect and use of DRDA.
As far as the mainframe and z/OS are concerned, everything you need for
DRDA is included with DB2 (and TCP/IP). You can find the enablement of
DRDA in the DB2 for z/OS pubs (including enablement of the DDF address
space).
It is only if you want to access DB2 for z/OS from OFF the z/OS platform
(normally from Windows/Linux/UNIX) that you need to purchase DB2 Connect.
Larry Edelstein
Much appreciated. Yes the client will be on Windows or any other
non-IBM box. The driver I am investigating is a 3rd party one, and
needs nothing else on the client end. I was just making sure that
the use of that type-4 driver did not require anything extra on the
DBMS end.
Joe Weinstein at BEA Systems
We use an AIX third party odbc driver that does not require db2
connect.
Arthurccc wrote:
type 4 driver still need IBM licence.
Larry wrote:
Joe ... you will need to check with your type-4 driver vendor to find
out how their driver connects to DB2 for z/OS (if at all). If it is a
basic JDBC driver without any special DB2 for z/OS connectivity that is
provided by that vendor, then I believe you will have to use DB2 Connect
(DRDA).
Larry Edelstein
jo***********@g mail.com wrote:
Larry wrote:
>
>>Joe ... I'm still not sure I understand what you are trying to
>>accomplish. Are you trying to access DB2 on z/OS via a Java type-4
>>driver from a client that resides on Windows/Linux/UNIX? If that is the
>>case, then if you want to do it with the IBM Java type-4 driver, this
>>requires licensing of DB2 Connect and use of DRDA.
>>
>>As far as the mainframe and z/OS are concerned, everything you need for
>>DRDA is included with DB2 (and TCP/IP). You can find the enablement of
>>DRDA in the DB2 for z/OS pubs (including enablement of the DDF address
>>space).
>>
>>It is only if you want to access DB2 for z/OS from OFF the z/OS platform
>>(normally from Windows/Linux/UNIX) that you need to purchase DB2 Connect.
>>
>>Larry Edelstein
>
>
Much appreciated. Yes the client will be on Windows or any other
non-IBM box. The driver I am investigating is a 3rd party one, and
needs nothing else on the client end. I was just making sure that
the use of that type-4 driver did not require anything extra on the
DBMS end.
Joe Weinstein at BEA Systems
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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
|
by: Scott |
last post by:
Has anyone setup DB2 8.1 (fix patch 7) on Windows 2000 to be a DRDA
server? I want to have an iSeries with OS400 V5R2 act as a DRDA client
to an 8.1 DB2 UDB database hosted on Windows and so it can access the
data stored on the windows database. What are the steps to set this
up?
Also, is this the best way to go about accessing a windows db2 8.1
database from an application running on os400 v5R2 release?
|
by: Jochen Luebbers |
last post by:
Hi,
I've a problem:
I compile modules of embedded SQL (for a dynamic lib) on multiple
platforms (AIX,Linux,Windows). They are compiled from the same
source code. To be able to provide all platforms at the same time
on ONE database (server), I want different package names -
e.g. module1.sqc should produce packages AMOD1, LMOD1, and WMOD1.
So I tried the following db2 call for preparing:
|
by: tony zheng via DBMonster.com |
last post by:
Hi,any one know ,in DRDA enviroment DB27.1 running in ZOS/E,I find when
apllication program access DB2 through DB2connect ,in mainframe two address
space TCPIP and DIST CPU usage were very high ,and DBM1 or MSTR address are
low,one sample maybe 15%(tcpip),10%(DIST),1%(DBM1),we are 100% DRDA
envirnoment,I don't know is it normally?
Do anyone has experience on this area?Hope can help me,thanks
--
Message posted via http://www.dbmonster.com
|
by: Joe Weinstein |
last post by:
Hi, and thanks in advance...
Can DB2 can exist/run on z/OS without DRDA available for clients?
thanks,
Joe Weinstein at BEA Systems
| | |
by: jeethsu |
last post by:
Hi,
I have Java application running on Websphere Application Server 6.0 This application connects to Mainframe DB2 using CLI type 2 driver. The application uses websphere connection pool mechanism.
I have stored procedures which are called from the application and one particular stored procedure call throws the below error:
SystemErr R SQL exception: com.ibm.websphere.ce.cm.StaleConnectionException: CLI0108E Communication link...
|
by: Laurence |
last post by:
Hi all,
Does connection concentroator only support in DRDA environment?
Thanks in advance,
Laurence
|
by: tomhanks |
last post by:
Please help my diaglevel is at 3 still i get these messages. My platform is Aix 5.2
2007-04-25-01.08.04.209068-300 I12660C351 LEVEL: Severe
PID : 38574 TID : 1 PROC : DB2_UDB
INSTANCE: db2d01 NODE : 000
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30 MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x2FF1FE48 : 0000 003C ...<
...
|
by: Scav |
last post by:
Helpful folks,
I am having a problem getting Oracle's Transparent Gateway for DRDA
product to interface with DB2 UDB for LUW 8.1.14.
The Gateway product is running on Linux and using DRDA protocol to
connect to my DB2 test server, which is running on Win2003. This test
server has recently been migrated to V8. It was previously on V7.2
FP5, and here is where the mystery lies.
|
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...
|
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,...
| | |
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
