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.
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 philpl1jb44,150 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
Hi,
Possibly a SELECT/OMIT on a logical file? Just a guess…
Regards,
Martin Gilbert.