RE: Time taken to build new Access path on file with Deleted Records

Did you consider running RGZPFM while active to get rid of the deleted records?
A file this large could take a day or so, depending on the iSeries model, how many access paths over the PF, and what version of i5/OS.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Tuesday, September 24, 2013 10:07 AM
To: Midrange Systems Technical Discussion
Subject: Re: Time taken to build new Access path on file with Deleted Records

Of course. To build an access path you have to page in all the data and if
90 pct of what you are getting is deleted records it is going to take longer.
On Sep 24, 2013 7:42 AM, "Vinay Gavankar" <vinaygav@xxxxxxxxx> wrote:

Hi,

Is there any substantial difference in the time taken to build an
Access path for a new logical file if the physical file has a high
number of deleted records.

The file I am concerned about has only about 4.5 million records but
it also has about 300 million Deleted records.

All other things being equal, would the time to create a new logical
differ, if there were no deleted records?

TIA
Vinay
--
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.

--
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.