|
The question is what's going on here? If there is an access path created by the CRTLF command why doesn't it just display the data? Other logical files instantly display records.
Greg,I also had same problems time ago. I never understood why the "optimizer" is "too much clever" and takes the wrong way...
Anyway, just make a very quick test:Go to STRSQL and try "Select * from FILENAME optimize for 1 rows" where FILENAME is your Logical File
Do you get an instantaneous answer with your data? Other answers to your original post have addressed different topics.I would suggest you search (lots of links... take this one just as a sample:
http://www-912.ibm.com/s_dir/slkbase.NSF/ce197905697c4c6086256a4f007978f7/9fbb11f1725466578625694c007511a1?OpenDocument
) on topics on "QAQQINI" file. In the previous link, search for "OPTIMIZATION_GOAL" and read on "*FIRSTIO". Different QAQQINI's could serve different goals depending of type of job... You could create your own QAQQINI file (that link shows you how to do it) and customize it to your own needs, whether for testing purposes, batch or interactive, etc. Just read many other documents on QAQQINI before you take your own decissions! But as that document reads in its first paragraph, "Use of this support on a system-wide basis is rarely advisable".
Another link I would suggest to read:
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzajq/rzajqmstqueryopt.htm
As I mentioned, there are tons of documents on this and similar topics... HTH,
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
