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

You should run the performance tools on these transactions.  I would bet
that you're building an index on the fly for OPNQRYF or embedded sql, etc.
Performance tools will tell you if there's a new access path that should be
built to improve performance.



++++++++++++++++++++++++++++++++++++++++++++
Go... FASTER!  Without an upgrade!  With ARCTOOLS/400(tm)!
Reorganize files without locking out the users!
http://www.arctools.com
info@xxxxxxxxxxxx 
DCSoftware, Inc.
Ph: (508) 435-8243
Fax: (508) 435-4498
++++++++++++++++++++++++++++++++++++++++++++

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

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