Managing sort performance
R+/CHANGE ACCUM cannot determine the exact size of the sort because the log records are sorted as they are extracted from the log files.
The NUMREC and AVGRECSZ options that are provided with R+/CHANGE ACCUM allow you to specify sort sizes. You can use NUMREC to specify the estimated number of records to pass to the sort routine, or R+/CHANGE ACCUM can provide the estimate.
If you specify or use the CALC option implicitly, R+/CHANGE ACCUM can estimate the number of sort records. It estimates one log record per control interval.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*