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

Why are you assuming it's a deleted record problem ?

Yes, 20% deleted is high and should either be addressed with a reorg and
probably a reusedlt(*yes) as others are suggesting.

Since you're not sure about the SETLL, check the program stack and find the
program statement (or loop) that is being executed when the delay occurs.

Some things to check...
How many logicals are built over the file (do a DSPDBR) ?
Any multi-format (multiple physical files) logicals ?
Any select/omit ?  DYNSLT ?

For large files, access path maintenance starts to be a problem.  Slow
performance on writes and updates (where keys change).


Keith


----- Original Message -----
From: "Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, July 01, 2003 6:57 PM
Subject: deleted records in file causing performance problem - HELP!!


>
> 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.
>
> I thought dspjob option 14 would reveal if the database is reading thru
> 1000's of deleted records, but apparently I cannot see that this is
> occurring, and which file is causing the problem.
>
> Is there any OS400 command to see my program reading thru thousands of
> deleted record slots?
>
> The file is set to reuse deleted records = *no.
>
>
> PS only one or two activation groups exist, so I dont think it is building
> 1000's of those.
>
> Also, other AS/400 programs running on the same PC on different
> Client/access sessions are working fine.
>
> Thanks!!
> _______________________________________________
> 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.
>
>