Re: File Reorg - Cons

[Dan Rasch <drasch@xxxxxxxxxxxx>]

One aspect of REUSEDLT(*YES) that can be tricky is to remember when the
DSPPFM command is used, the newest record will likely be somewhere in the
middle of the file.  Not a show-stopper, but something to keep in mind. 

Back in the Stone Age (early 90's), we had a program that did not appear
to be adding the new records (and we watched it in debug) - only to find
the records WERE there, but not where we expected.


Dan Rasch - because if the human species concentrated on the really 
important things in life, there would be a shortage of fishing poles!
IBM Certified twice....... but still a couple PTFs away from Nirvana.

On Wed, 28 Apr 2004, David Gibbs wrote:

> Mike Berman wrote:
> > I noted alot of suspicion when I attempted to set up a file reorg
> > process. Just getting lists of those with large amounts of deleted
> > records. Is there some possible occurance that would be a detriment?
> > I am of course referring to off hours running.
> 
> If you have applications that are deleting and creating a lot of records 
> on an ongoing basis ... might want to set REUSEDLT(*YES) so you don't 
> have to reorg the files often.
> 
> I seem to remember Al Barsa mentioning that there might be a trade off 
> when using that feature ... might want to check the archives for that.
> 
> david
> 
> _______________________________________________
> 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.
> 
> 
>