Re: Anyone have RGZPF?

[rob@xxxxxxxxx]

One may want to consider the effect of reorganizing a file based on one of
it's index's (or logical files, for those stuck with DDS).  You'd have to
have poorer performance after doing a RGZPFM done with a utility versus a
RGZPFM done with a good KEYFILE option.

Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    Carel Teijgeler                                             
                                         
                    <teygeler@bart.nl>         To:     MIDRANGE-L@midrange.com  
                                         
                    Sent by:                   cc:                              
                                         
                    owner-midrange-l@mi        Subject:     Re: Anyone have 
RGZPF?                                       
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    12/28/00 12:52 PM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




"Shaw, David" wrote:

> Yo!
>
> Years ago News/400 published a utility called RGZPF which was handy for
> reorganizing files in a library.  I used it at my previous employer, and
I
> imagine they're still using it.  I didn't think to make a copy of it to
> bring here, assuming I'd be able to get it from the CD or web site.
> Unfortunately, it was published too far back to be available on either!
> Does anyone have a copy of it that they'd be willing to e-mail to me?  I
> could re-write it from memory, but I'd rather save the debugging time if
> possible.  Thanks!
>
> Dave Shaw
> Spartan International, Inc.
> Spartanburg, SC

Dave,

This is a simple utitlity you can write yourself.

Just do a DSPFD TYPE(*MBRLIST) of the required library (only the *PF) to an
outfile.
Read through the outfile and test the field "Number of deleted records".
If grater than 0, run RGZPFM command with the fields supllied by the
outfile.
So all members of all the requested files in the requested library will be
reorganized.

If you have a little patience, I can e-mail you such an utility in the next
year
with the posibility to reorganize 50 libraries as a maximum.

Regards,

Carel Teijgeler.

+---
| 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
+---