Suppressing internal sort

When you request Accounting functions only, it is often possible to avoid the OMEGAMON for Db2 Performance Expert internal sort of the input data. Suppressing the internal sort with the PRESORTED option of the GLOBAL command reduces the size of the sort work files that must be allocated and the processing time.

The PRESORTED option of the GLOBAL command controls the internal sort. For example, to produce an Accounting report without sorting the input data, specify:



The resulting Accounting report shows Accounting data for all locations in the input data set, without performing an internal sort.