Intermittent 0C4?s, 0F1, and 80A abends when processing large amounts of data in daily.

Document ID : KB000030697
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

Intermittent 0C4’s, 0F1, and 80A abends when processing large amounts of data in CA MICS daily jobs that use DFSORT.

Environment:  

CA MICS sites at SAS 9.3 and above, with IBM DFSORT.

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. Consequently, the use of REGION=0M makes all of the allocated memory available to the sort. This results in the recommendation to use MEMLEAVE and SORTBLKMEM to restrict the memory used.

Workaround:

As a workaround, set MEMLEAVE=500M & SORTBLKMEM=50.  Also specify REGION=0M on the DAILY jobcard.

Here is a SAS support link: http://support.sas.com/kb/49/653.html

Additional Information:

With SAS 9.4 a new parameter, SORTBLKREC, has been added. Per SAS Usage Note 57676: Improving performance of SAS® software with the host sort utility DFSORT, the optimal setting is SORTBLKREC=5000.