Ok, the plot thickens. I'm trying to identify and rebuild LFs that after an abnormal shutdown and normal ipl, are no longer being selected for SQL and QRY. These files are not damaged, but program response has taken a major hit due to these views not being selected.
After researdhing one known file before and after rebuilding, the discrepancies that I find are that
1. access path valid field was set to "N" (MBINDX field is dspfd)
2. Index entry Count was = 0
3. Index size was miniscule
These LFs have gone from heavy daily usage to *none. Recompiling the LF corrects the problem.
How and why does the MBINDX field get set to "N"? What's considered a valid access path?
June 17, 2009 3:23 PM
June 18, 2009 8:04 PM