× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



You can reorganize the file to physically remove the deleted records.
Use the command RGZPFM.
Hope that helps.

"Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx> wrote:
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 RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



Michael Gottlieb  
gottlm@xxxxxxxxxxxxx
gottlm@xxxxxxxxx
 
Out of every 10 people, one understands binary, the other doesn't.
 



---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.