CA WA ESP History Report job gets error message "ESP991E ERROR OCCURRED DURING SORT"
search cancel

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

book

Article ID: 4953

calendar_today

Updated On:

Products

ESP Workload Automation

Issue/Introduction

Running a large History Report job and gets CA WA ESP error message "ESP991E ERROR OCCURRED DURING SORT". 

 

Environment

CA Workload Automation ESP Edition r11.4.IBM DFSORT

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)