Re: Reuse vs. Reorg

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

Unless there is a program/process that uses this file by RRN then I would 
go for REUSE.

Thanks,
Tommy Holden



From:   daparnin@xxxxxxxxxxxxxx
To:     midrange-l@xxxxxxxxxxxx
Date:   09/24/2010 08:41 AM
Subject:        Reuse vs. Reorg
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



We have a file that is somewhat dynamic.  Records are generated, they are 
kept for awhile, some are deleted, others are generated, and so on.  The 
deleted records increases by about 100,000 per day.  We run a reorg once a 

week to get the deleted records back.  I had thought about changing the 
file to reuse deleted records to minimize the need to do reorgs.  Is there 

any downside to this?  My boss thought that if the default for files was 
*NO then there might be a reason that we wouldn't want to do it.  This 
isn't a file where we would want/need to reactivate the deleted records. 
It would be easier to restore from a backup or just regenerate them. 
Thoughts?


Dave Parnin