155 pts.
 DSPFD – Asking for some explainin about a field in DSPFD output
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.

Software/Hardware used:
ASKED: May 21, 2009  7:49 PM
UPDATED: May 22, 2009  2:45 PM

Answer Wiki:
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.
Last Wiki Answer Submitted:  May 22, 2009  2:45 pm  by  philpl1jb   44,630 pts.
All Answer Wiki Contributors:  philpl1jb   44,630 pts. , QPFRADJ   155 pts. , ReshmaG   445 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Hi,

Possibly a SELECT/OMIT on a logical file? Just a guess…

Regards,

Martin Gilbert.

 23,625 pts.