Can DB2 run on z/OS without DRDA access?

joe.weinstein

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

joe.weinstein

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

Larry

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

joe.weinstein

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

Larry

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

joe.weinstein

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

Larry

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

Arthurccc

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

sethwai

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