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

Can DB2 run on z/OS without DRDA access?

P: n/a
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
Share this Question
Share on Google+
8 Replies


P: n/a

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

P: n/a
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

P: n/a

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

P: n/a
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

P: n/a

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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.