SAS system option SORTBLKREC= improves performance when using DFSORT utility.
search cancel

SAS system option SORTBLKREC= improves performance when using DFSORT utility.

book

Article ID: 38926

calendar_today

Updated On:

Products

MICS Resource Management

Issue/Introduction

Poor sort performance with SAS 9.4 and DFSORT Utility.

 

Environment

Release: r14 MICS Sites at SAS 9.4 (TS1M3) and above and using the IBM DFSORT Utility.

Cause

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.

Resolution

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.

Additional Information

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).