ESP History Report job gets error message "ESP991E ERROR OCCURRED DURING SORT"

Products

• ESP Workload Automation

Issue/Introduction

Running a large History Report job and receiving error message "ESP991E ERROR OCCURRED DURING SORT". 

 

Cause

To determine the cause of ESP error "ESP991E ERROR OCCURRED DURING SORT", add the following statements to the ESP History Report job:

//SORTDIAG DD DUMMY 
//SYSOUT DD SYSOUT=* 

Sample sort sysout:

ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT  215518 
ICE253I 0 RECORDS SORTED - PROCESSED: 215518, EXPECTED: 0 
ICE753I 1 FWK=(5,2660) SWK=(0,0) TWK=(0,0) RWK=(2,1104) TOTAL=(7,3764) BLK=12256 
ICE278I 1 5 WORK DATA SETS WERE INSUFFICIENT TO COMPLETE THIS SORT ... 

In this case, the cause of ESP error ESP991E is "SORT CAPACITY EXCEEDED". 

 

 

 

Resolution

Use the DFSORT DYNALLOC=(,n) parameter to increase the maximum number of sort work data sets.

This is done by adding the following statements to the History report job: 
//DFSPARM DD * 
OPTION DYNALLOC=(,50)