Re: Are we insane? Unique use of native DB2

On 14/03/2008, at 4:29 AM, Crispin Bates wrote:

I think you might be mistaken. I remember it being new on the /400, sometime
within the last decade or so (may be a little longer). Can't remember when.

I cannot address whether automatic access path sharing was in place on Release 3 of CPF (well before my time) but it was there in Release 8. We used to ensure longest key indices were built first to improve chances of sharing and periodically would delete and rebuild in this order to save DASD space and improve performance.

Have a look at the REFACCPTH keyword in DDS for a LF...

That is a new keyword with OS/400 and appears to be a replacement for ACCPTH which was the keyword originally referred to. That keyword is not valid in native logical files--only in LF38 ones

There are implementation differences between the two keywords (which is why I presume they exist) but from a development perspective they appear to perform the same function.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------