Re: Physical and Logical File Reorganizing Questions

[Donald Whittaker <donald_whittaker@xxxxxxxxx>]

   In addition to the all the good points made by
others, you may want to look at reusing deleted
records (REUSEDLT parm on create/change file -- really
more of a "reclaim" than "reuse").  This impacts
arrival sequence and efficiency of indices but it can
help with disk space issues, which sounds like one of
your concerns.

For what it's worth...

Don Whittaker


--- 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
> 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-
> 
>  
> 
> -- 
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 
> 



                
__________________________________________ 
Yahoo! DSL ? Something to write home about. 
Just $16.99/mo. or less. 
dsl.yahoo.com