Re: deleted records in file causing performance problem

Y'all

<commercial> We have a product, lock/DETECTOR, that reports extant locks while it is run. It gives you information that is time-consuming to gather otherwise.

Could probably get you a trial copy (less than 2 meg) if you think it'd help. It's usually on a CD with a few other tools. </commercial>

Vernon M. Hamberg (Vern)
Senior Software Engineer
Centerfield Technology, Inc.
507.287.8119 x111

At 10:57 PM 7/1/2003 -0500, you wrote:

Is it the same "some users" experiencing the delay, and not the rest?

Is it time-of-day? Type of order?


(I am suspicious that there is a record lock occurring for some reason, and
the user is held up until the lock is released by some other event.  The
fact that some users are ok and others are not makes me suspect it is not
related to the deleted records.

---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------

-------Original Message-------

From: Midrange Systems Technical Discussion
Date: Tuesday, July 01, 2003 9:25:51 PM
To: 'Midrange Systems Technical Discussion'
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.

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