RE: Reclaiming Delete Record Space....

RE:     RE: Reclaiming Delete Record Space....


        >You could cpyf to a tape from disk and then delete and cpyf it
        >back to disk minus deleted records..... 
        >Quick, clean, easy.....

>What advantage would this have over RGZPFM though? Isn't this how it
>works??? Copy/Compress Deleted Records... Delete... Rename... 
>I probably couldn't save anytime. I'd still have a complete rebuild of
>all the access paths...
>I beginning to think that there is really only one way to do this....
>RGZPFM
:( >Kenneth

Well ya, duh. 
Reorganize Phyical File Member.   It kinda looks like that is what
it was designed to do.   You could do some fancy-smancy stuff like 
Removing the Logicial file members before.  This will speed up the 
reorg it self a lot if there are lots of access paths and lots of records.
But then you would have to add them back afterwards.   But you would have
the decision of which ones, and when.  

Or change the access path maint on the LF's to *Rebuild  before the 
reorg and change back to *DLY or *IMMED afterwards.  This would be safer
since programs would not blow up for no member.

We just changed all the files to reuse deleted records *YES.  To hell with 
any performance difference. 

  Remember, I was one of the people using date
data types when everyone else was saying "oh,oh,oh, the performance"  
#$%#@ the performance.   We never noticed any performance problems.
YOU NEVER NOTICE in most cases.  (Disclaimer;there are always 
individual case exceptions. I'm speaking of rules of thumb here)

No performance flames please.

John Carr
EdgeTech (Have classes,  Will travel)
+---
| 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
+---