RE: Reclaiming Delete Record Space....

[Joe Giusto <JGiusto@xxxxxxxxxxxx>]

Yes, that makes sense.  I usually copy FROMREC(1) when making copies of
files (like before running a major update procedure) instead of
CRTDUPOBJ.  This gives me an exact picture of the way the from file was
organized.  I have also noticed (at least back from my SYS38 days where
I picked up this habit)  that the copy works quicker.

Thanks,

Joe Giusto II
Patuxent Publishing Company
mailto:JGiusto@patuxent.com
http://www.lifegoeson.com <http://lifegoeson.com> 


        -----Original Message-----
        From:   Pete Massiello [SMTP:pmassiello@os-solutions.com]
        Sent:   Wednesday, September 16, 1998 6:34 PM
        To:     MIDRANGE-L@midrange.com
        Subject:        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
        +---
+---
| 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
+---