473,327 Members | 1,892 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,327 software developers and data experts.

Can DB2 run on z/OS without DRDA access?

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

Aug 29 '06 #1
8 2067

Sorry for the duplicate post. I was having trouble with one of the
netscape newsreader, and didn't think it went through.
Joe

Aug 29 '06 #2
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***********@gmail.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
Aug 29 '06 #3

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

Aug 29 '06 #4
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***********@gmail.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
Aug 29 '06 #5

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

Aug 29 '06 #6
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***********@gmail.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
Aug 30 '06 #7
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***********@gmail.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
Aug 30 '06 #8
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***********@gmail.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
>
Aug 30 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

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...
0
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...
17
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...
1
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...
0
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
0
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...
1
by: Laurence | last post by:
Hi all, Does connection concentroator only support in DRDA environment? Thanks in advance, Laurence
0
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 ...
5
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...

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.