Re: Reclaiming Delete Record Space....

Joe,

    I dont know if you were responding to a specific question or not. If you 
were
not then, If you are mostly reading by this key, you would want them to be in
this key order (or the order of the key that you use the most), this way as you
bring a page of records into memory, your chances of using another record in 
that
page increases, thereby reducing the number of physical I/Os.

  Pete Massiello

Joe Giusto wrote:

> Don't forget the FROMRCD(1) to keep the records in the same RRN order.
> If the file is keyed and you copy without this, they will be physically
> arranged in the keyed order.
>
> Joe Giusto II
> Patuxent Publishing Company
> http://www.lifegoeson.com
> mailto:JGiusto@patuxent.com
>
>         -----Original Message-----
>         From:   PaulMmn [SMTP:PaulMmn@ix.netcom.com]
>         Sent:   Thursday, September 03, 1998 9:24 PM
>         To:     MIDRANGE-L@midrange.com
>         Subject:        Re: Reclaiming Delete Record Space....
>
>         >Is RGZPFM the only way you can remove delete records from a
> physical
>         >data file or can it be accomplished via some save restore
> process too?
>         >
>         >Kenneth
>
>         A CPYF will also compress out deleted records.  Of course, the
> file is no
>         longer where it used to be; you have to copy it back to leave
> things as
>         they were.
>
>         --Paul E Musselman
>         PaulMmn@ix.netcom.com
>
>         +---
>         | This is the Midrange System Mailing List!
>         | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
>         | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
>         | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
>         | Questions should be directed to the list owner/operator:
> david@midrange.com
>         +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---



--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---