Can DB2 run on z/OS without DRDA access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joe.weinstein@gmail.com - 29 Aug 2006 21:28 GMT

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

Reply to this Message

joe.weinstein@gmail.com - 29 Aug 2006 21:30 GMT

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

Reply to this Message

Larry - 29 Aug 2006 22:11 GMT

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

> 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

Reply to this Message

joe.weinstein@gmail.com - 29 Aug 2006 22:20 GMT

> 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

Reply to this Message

Larry - 29 Aug 2006 23:47 GMT

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

>>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
[quoted text clipped - 9 lines]
> item (DRDA access).
> Joe

Reply to this Message

joe.weinstein@gmail.com - 30 Aug 2006 01:09 GMT

> 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
[quoted text clipped - 11 lines]
>
> 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

Reply to this Message

Larry - 30 Aug 2006 01:46 GMT

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

>>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
[quoted text clipped - 18 lines]
> DBMS end.
> Joe Weinstein at BEA Systems

Reply to this Message

Arthurccc - 30 Aug 2006 02:57 GMT

type 4 driver still need IBM licence.

> 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
[quoted text clipped - 26 lines]
> > DBMS end.
> > Joe Weinstein at BEA Systems

Reply to this Message

sethwai@yahoo.com - 30 Aug 2006 14:48 GMT

We use an AIX third party odbc driver that does not require db2
connect.

> type 4 driver still need IBM licence.
>
[quoted text clipped - 28 lines]
> > > DBMS end.
> > > Joe Weinstein at BEA Systems

Reply to this Message