Re: DRDA Exit Point

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

I think any DRDA exit point is for requests coming into the machine from 
outside. No need to write an ARD. The other machine would be another 
iSeries or a mainframe or Windows/Unix/Linux version of DB2, probably.

Turns out this is handled by the DDM exit, which is defined in the CHGNETA 
command. Here is something from V4R? on it, and later releases should have 
this in place.

IBM DRDA does not provide a user exit, but new function has been added to 
the DDM user exits to support DRDA. This is possible because DRDA utilizes 
DDM support. PTF SF46018 adds this function to V4R1M0, and SF46017 adds 
this function to V4R2M0. The cover letter explains how to implement this 
function and provides a sample PL/I program. Information on DDM user exits 
can be found in chapter 4 of the Distributed Data Management manual 
(SC41-5307). The PTF cover letter explains the additional information 
needed to use the exits with DRDA.

If you are using DDM exit points and apply these PTFs, a problem could 
arise if you fail to change the exit program's handling of unknown function 
codes and are also using DRDA. This is explained in the cover letter. PTF 
SF46017 was included in Cumulative PTF Package 8028. Its supersede, SF46350 
was included in Cumulative PTF Package 8083. PTF SF46018 has been 
superseded by SF46698. Neither of these PTFs have been on a Cumulative PTF 
Package. Since these PTFs were included on V4R2M0 Cumulative PTF Packages, 
it is possible DDM exit programs could unexpectedly start rejecting DRDA 
requests that were previously allowed. Upgrading to V4R3M0 or above could 
also start causing unexpected failures because these changes are in the 
base of newer releases. In this case, the exit program needs to be changed 
to handle DRDA requests.

Found this by searching on "drda exit" in the iSeries Support search engine.

HTH
Vern

At 02:36 PM 5/11/2005, you wrote:

> Thanks.
> What I am looking to do is to intercept the DRDA request before it is 
> processed and do some validation on the library/file being requested based 
> on user id.
> Do I need to write an ARD, or is there an exit point or some other method 
> available to do this.
>
> Thanks,
>
>
> vhamberg@xxxxxxxxxxx wrote:
> That's right, ODBC is not the same thing as DRDA - not even related, 
> although they both provide ways to get data from remote databases. You 
> have to have a DRDA provider, known as an ARD or application requester 
> driver. This is equivalent to an ODBC driver or OLE/DB provider. These 
> need to be provided by the maker of the database. Hardly any RDBMS' have 
> done this for the iSeries.
>
> An iSeries can connect with another iSeries or with any DB2 system with 
> DRDA, so that is probably where this comes into play.
>
> HTH
> Vern
>
> -------------- Original message --------------
>
> > Jeffrey,
> >
> > As no one has answered, yet.
> >
> > I looked at CLI programming three weeks or so and I saw only one exit 
> point for
> > DRDA mentioned. Browsing the docs of that it looks to me a possibility 
> to write
> > your own ARD programme.
> >
> > Thus, I think not.
> >
> > Regards,
> > Carel Teijgeler.
> >
> > *********** REPLY SEPARATOR ***********
> >
> > On 9-5-05 at 12:31 Jeffrey Young wrote:
> >
> > >Is the exit point for DRDA requests the same as for ODBC (QIBM_QZDA_SQL2
> >
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> Jeff Young
> Dynax Solutions, Inc.
> IBM  Certified Systems Exper - iSeries Technical Solutions V5R2
>
>
>
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
>  Make Yahoo! your home page
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.