Problem solve Get help with specific problems with your technologies, process and projects.

Speeding up OPNQRYF on large files

Is there any way to speed up OPNQRYF on large files?

When using OPNQRYF, I try to keep the number of records being queried as small as possible. If this is for a report, you may be able to produce a subset of records to a separate file and then do an OPNQRYF over the subsetted file to speed things up. If all else fails and you have to run OPNQRYF over a large file, OPNQRYF will run faster if it can take advantage of an existing access path that matches your record selection criteria. If there is not a suitable access path for OPNQRYF to use, it will create the access path at the time of execution, which will slow down the OPNQRYF process.


The Best Web Links: tips, tutorials and more.

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

Dig Deeper on iSeries ILE programming

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.