I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file.
I am accessing keyed logical file based on physical which contains 180 Million records.
Can anyone please suggest any ideas to reduce the time taken to select the records from this huge input file to generate the output extract.
your help is greatly appreaciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!