DSPFD – Asking for some explainin about a field in DSPFD output

155 pts.
Tags:
AS/400 Records
DSPFD
Would you kind to explain me what reflects the field "Rejected records by key selection" ?, What could be the reason for rejecting a record in a I/O operation. Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi
Please explain your question.

Thanks
Reshma

People, thanks for so quickly response. I’m trying to get some information about the i/o charge on the system during online an during batch time. Executing DSPFD on the files of several libraries I remarked that one file contains statictis of billions of records rejected by key selection. (I beg yor pardon if the field’s name does not match exactly I’m translating from Espanish). The file contains only 2.5 million of registers of 26 bytes length.

That’s the reason I want to know what kind of action makes that field by filled. Sorry for my bad English.

=========================================
Here’s a site

http://forums.systeminetwork.com/isnetforums/showthread.php?t=44919

It’s not at all clear to me why keyed input requests should look at records and reject them — dynamic select? Selects/Omits, or just the way the system uses it’s indexs. I think this is a new statistic 6.1??? and I’m surprised that I don’t find an explanation on line. I would think that lowering this number would be good — but how? And why did they collect this info if it wouldn’t help us tune the database?

Could it be from SQL Joins?

Heck, I’ve found explanations on-line for everything else, alien spaceships, Elvis.

Phil

I checked the link and read that explanation. Then I remaked it would happens because the programs are made by Genexus which generates RPG source y compiles that. In Genexus the programmers use the keyword WHEN and join the fields of several files not considering the size of them, so, the reading for compare the conditions in the WHEN, occurs in a parallel way (taking a lot of time) instead of generating a vector with the little file, or separating the reading in several when. Thanks a lot.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Gilly400
    Hi, Possibly a SELECT/OMIT on a logical file? Just a guess... Regards, Martin Gilbert.
    23,730 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following