Chuck,
I'm not going to doubt your word on it, you probably looked at the code :-)
On page 10 of the document in the following link, Dan Cruikshank says it
wasn't on the S/38, and you had to use REFACCPTH.
http://www-03.ibm.com/servers/eserver/iseries/db2/pdf/Performance_DDS_SQL.pd
f
http://tinyurl.com/3889l6
I worked on the S/36 and S/38 prior to moving over to the /400 in '89.
Unfortunately, my poor old head can't remember that far back (or perhaps it
is the foggy recollection that are that far back), but I could have sworn
that it was something that wasn't on the earlier releases on OS/400. Perhaps
what I am remembering is seeing it on the AS/400 when I had not seen it on
the S/38...
Anyway, thanks for putting me straight on that one :-)
Crispin.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Thursday, March 13, 2008 8:33 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Are we insane? Unique use of native DB2
Well over two decades since Access Path sharing was introduced on the
R7 of S/38. I thought the REFACCPTH was a carry-over from the S/38 and
that it was deprecatory usage, but seems it was new on V1R1M0. It is
the ACCPTH keyword usage that is deprecatory; maybe only allowed on the
LF38, since I can not find it in the DDS manual? An ACCPTHMBR parameter
was on S/38 CRTLF, but none for OS/400.
Regards, Chuck
midrange.com
