Abend S04E REASON 00E40005 executing Db2 reorg during Database Management Post Install Compare ssid0000 or Create ssid0001
Article ID: 282393
Updated On:
Products
Issue/Introduction
Executing Database Management Solutions for Db2 for z/OS Post Install Compare ssid0000 or Create ssid0001 where Db2 reorg execution abends
with S04E REASON CODE 00E40005. Both the Db2 SDSNEXIT/SDSNLOAD and new Database Management Solutions r20 CDBALOAD are APF authorized.
One of the following are the relevant messages from the step where the Db2 reorg utility is executed:
SYSTEM COMPLETION CODE=04E REASON CODE=00E40005
PSW AT TIME OF ERROR 077D3000 A182EA46 ILC 2 INTC 0D
ACTIVE MODULE ADDRESS=00000000_216BF000 OFFSET=0016FA46
NAME=DSNUT121
DSNU044I 112 20:51:11.29 DSNUGSRP - ERROR FROM SORT COMPONENT RC=16, UTILITY STOPPED
DSNU016I 112 20:51:11.29 DSNUGSAT - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40005'
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT XXXXXXX
or
SYSTEM COMPLETION CODE=04E REASON CODE=00E40005
PSW AT TIME OF ERROR 077D3000 AC56567C ILC 2 INTC 0D
ACTIVE MODULE ADDRESS=00000000_2C400000 OFFSET=0016567C
NAME=DSNUT121
DSNU044I 112 20:51:11.29 DSNUGSRP - ERROR FROM SORT COMPONENT RC=16, UTILITY STOPPED
DSNU016I 112 20:51:11.29 DSNUGSAT - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40005'
ICE185A 0 AN S04E ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT
Resolution
If ICE185A 0 AN S04E ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT
Adding a proper REGION= specification (example REGION=0M) to the step itself or JOBCARD resolved the problem.
If ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT XXXXXXX
Editing hlq.CDBASAMP member ssidDDL adding operand SORTNUM with an appropriate value such as 32 for the reorg tablespace executions
failing with this error resolved the problem.
Additional Information
Per IBM documentation for Db2 REASON CODE 00E40005:
System action
Any error message generated by sort in conjunction
with the nonzero reason code is directed to the device/
data set identified by the UTPRINT DD statement in
the utility job step.
Error message DSNU044I, that contains the nonzero
reason code, is directed to the device/data set
identified by the SYSPRINT DD statement in the utility
job step.
If DFSORT cannot be loaded, the utility output
contains DSNU1640I.
Feedback
