Re: deleted records in file causing performance problem - HELP!!

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

Joel--

In contrast to what some others have said, if you're reading the file 
sequentially (in record arrival sequence), the deleted records 
-could- be causing your delay in reading the file.

We have a file of only about 3 million records with about 1/2 
deleted, and we've noticed a difference using the DBU utility-- try 
to read by relative record number (ie record arrival sequence), and 
you can wait a minute or two until the utility has read enough active 
records to fill a screen.  Access by a logical file, and a screen 
full of data is available 'instantly.'

Depending on where the deleted records in your file are, this could 
explain your delays.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx





Joel jotted (in part):

> I have a 30 million record file with 20% deleted records.
>
> Some users are experiencing delays (up to 1 minute) in a critical RPG
> interactive order entry program.
>
> I can't seem to find an IBM utility to help diagnose the error.
>
> I think the problem could be lots of deleted records in a file that the
> program is performing a SETLL on to check for record existence.