MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

RE: Massive Reorg



fixed

In the past I worked with JD Edwards/Oracle and the JDE Dream Writer function
created "mass quantities" of deleted records as a normal part of dream writer
report parameter use.

When reuse deleted records became available, it made my admin responsibilities
much easier because several of the JDE DW files were always high on my list
of files to re-org, and always difficult to obtain the exclusive lock needed
for the re-org.

By setting these files to reuse deleted records *YES, we saw the files
stabilize at a (for these files) reasonable number of active and
deleted rows - so no more Sunday night re-orgs for these files, and I
was, and still am, impressed by that.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, October 23, 2012 8:58 AM
To: Midrange Systems Technical Discussion
Subject: Re: Massive Reorg

Rob,

<snip/>
Not sure how deleted records helps concurrent inserts.
Perhaps also some application uses deleted records to 'preallocate' space.
</snip>

Not very sure but I seem to remember (long time ago), a comment from an IBMer about that one of the advantages of a file with REUSDLT(*YES) was improved performance at the moment of inserting a record, as it was faster to just insert it into a "slot" in, say, the middle of the file, that going all the way to the end and insert it there (and extend the file, I suppose).

So I suppose that for a process that, say, delete some hundred/thousands of records and then create new ones in their place, it would be better NOT to reorganize the file...

I think that I agree with Chuck that (*maybe*) it would be better to do RGZPFMs in a very selective way. Of course, every shop is different, and your mileage can vary...


Best Regards,


Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries





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