Poor sort performance with SAS 9.4 and DFSORT Utility.
Release: r14 MICS Sites at SAS 9.4 (TS1M3) and above and using the IBM DFSORT Utility.
The DFSORT Performance Booster is a collaboration between SAS Institute and IBM, where SAS will use an E13 exit to send blocks of data to DFSORT. DFSORT will return blocks of data using the E33 exit. The size of the blocks of records is dictated by the size of the buffer, which is set based on the available region.
Without the use of the SORTBLKMODE option, each record is passed individually.
The optimal performance is to specify SORTBLKMODE in sasprefix.CONFIG(SITE) and specify SORTBLKREC=5000 in sharedprefix.MICS.PARMS(MABATCH).
No CA MICS generation jobs are required to activate these changes.
SORTBLKMODE is the default if no value is specified.
Refer to SAS Usage Note 57676: Improving performance of SAS® software with the host sort utility DFSORT (http://support.sas.com/kb/57/676.html).