Please explain your question.
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
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.
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.