I would want to know the performance of this 2 commands OPNQRYF and CPYFRMQRYF. I will join 2 files and have some selection criteria. File A has 3000000 record and 1500000 number of deleted record in DSPFD. After that it execute CPYFRMQRYF command. So now the problem is this program take longer time to run. E.g. 2 mins to 30 mins. Why there is big different of processing time?
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!