MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » January 2006

Re: Physical and Logical File Reorganizing Questions



fixed

Just the physical. The command is Reorganize Physical File Member (RGZPFM).

On 1/5/06 04:25 PM, "Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx> wrote:

> Hi All,
> 
> 
> 
> When I'm performing a reorganize on files, do I need to do it on both
> the physical and logical files, or only on the physical file?
> 
> 
> 
> Let's say I have three files in the system:
> 
> 
> 
> ABC123 - PF (1000 records)
> 
> ABC123A - LF (250 records)
> 
> ABC123B - LF (95 records)
> 
> 
> 
> I deleted 50 records out of ABC123 (950 records remaining).  Of those 50
> records deleted, 25 of them were also in ABC123A and 5 records were also
> in ABC123B.
> 
> 
> 
> Two questions:
> 
> 
> 
> 1) If the same records were contained in the LFs (as indicated by 25 and
> 5 respectively), will they be updated by having the records deleted out
> of them as well?
> 
> 2) If #1 is yes, do I need to perform a reorganize on the logical files
> too?
> 
> 
> 
> The reason I'm asking is that we have several physical files (and many
> more child LFs) that need to be pruned every few months or they hog disk
> space like crazy.  I'm going to rewrite our quarterly batch job to clean
> up these files, and I want to ensure that all files will be cleaned.
> 
> 
> 
> Thanks!
> 
> 
> Brian.
> 
> 
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> Brian Piotrowski
> 
> Specialist - I.T.
> 
> Simcoe Parts Service, Inc.
> 
> PH: 705-435-7814
> 
> FX: 705-435-6746
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
> 






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact