Re: DRDA Exit Point -- MIDRANGE-L

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.