RE: Reclaiming Delete Record Space.Alternative option

["Graap, Ken" <keg@xxxxxxxxxxxxxxx>]

        >Using the REUSE DELETED RECORDS field in the file description
will also 
        >do this.  Depending on your release, IBM has a ptf that, when
applied, 
        >does away with having to run a rgzpfm if you are REUSING
DELETED 
        >RECORDS. We have a PF that takes almost 30 hours to reorganize
so you 
        >see how the REUSE DEL RCDS helps us.

        Ash... We are doing this, however there have been times when the
files in question "swell" to an unusually large size and then thousands
of records are deleted. The space is made available for new records, but
there are MB's of space that will never be filled again because of the
unusual event that occurred. 

        Some of the files I'm talking about are up to 8GB in size with
40,000,000+ records and 10-15 logical views over them.... Yikes!!!!!

        You can see why I'm trying to find an alternative to RGZPFM.

        I have read that I could remove the logical files and then do a
RGZPFM. The manual said that it would run much faster, but my concern is
that it will still take a VERY LONG time to recreate the logical
views....


Kenneth

--
********************************
        Kenneth E. Graap
  AS/400 Systems Administrator
    NW Natural - Information Services
             System Services
          503 226 4211 X5537
           FAX  503 721 2521
        keg@nwnatural.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
+---