Re: Sorting records in Physical and Logical files

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 22/08/2008, at 9:21 AM, Booth Martin wrote:

> As I understand the process, records are always added in arrival
> sequence,

Unless REUSEDLT is specified.

> and the key/address is loaded in arrival sequence also.  When
> the file is closed the keys themselves are sorted for performance
> benefits.

Keys are "sorted" according to the MAINT value on the file. For most  
access paths this is immediately (*IMMED). The close operation has  
nothing to do with it except in the case of *REBLD in which case the  
access path is destroyed rather than sorted.

> The records are left as-is until some action reorganizes them.

Correct.

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  / \
--------------------------------------------------------------------