2918427 - DB2 REORG fails with abend code S04E REASON=X'00E40347'

Db2 REORG executed out of Dbacockpit fails with abend code S04E , REASON=X'00E40347'.

Dbacockpit DSNACCMO job out reports the following.

20190614103020 RGT 10 9 0DSNU050I 165 10:30:26.57 DSNUGUTC -REORG TABLESPACE "DSN04239"."F1CRRFTG" SHRLEVEL CHANGE MAPPINGTABLE
20190614103020 RGT 10 10 SAPABAP.QT000001 COPYDDN(COPYTPL) RECOVERYDDN(COPYTPL) STATISTICS TABLE(ALL) USE PROFILE SAMPLE(10) INVALIDATECACHE
20190614103020 RGT 10 11 YES UNLDDN(UNLDTPL) SORTDEVT SYSDA DRAIN_WAIT 15 DRAIN ALL MAXRO 240 DELAY 900 LONGLOG CONTINUE TIMEOUT TERM RETRY
20190614103020 RGT 10 12 20 RETRY_DELAY 300 DEADLINE NONE PART 1
20190614103020 RGT 10 13 DSNU1361I -RRA 165 10:30:26.62 DSNUGPRF - THE STATS PROFILE WITH STATSTIME = 2019-05-11-14.24.19.032239 FOR TABLE
20190614103020 RGT 10 14 DBSTATC HAS BEEN USED
20190614103020 RGT 10 15 DSNU1368I 165 10:30:26.62 DSNUGPRB - PARSING STATS PROFILE FOR TABLE DBSTATC
20190614103020 RGT 10 16 DSNU1369I 165 10:30:26.62 DSNUGPRB - PARSING STATS PROFILE FOR TABLE DBSTATC COMPLETED
20190614103020 RGT 10 17 DSNU1173I -RRA 165 10:30:26.70 DSNURFIT - TABLE SPACE DSN04239.F1CRRFTG WILL BE CONVERTING FROM BASIC ROW FORMAT TO
20190614103020 RGT 10 18 REORDERED ROW FORMAT
20190614103020 RGT 10 19 DSNU2904I -RRA 165 10:30:26.92 DSNURFTB - DATA RECORDS WILL BE UNLOADED VIA TABLE SPACE SCAN
20190614103020 RGT 10 20 DSNU2903I 165 10:30:27.09 DSNURORG - PARTITION LEVEL INLINE COPY DATASETS WILL BE ALLOCATED
20190614103020 RGT 10 21 DSNU1038I 165 10:30:27.14 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=COPYTPL
20190614103020 RGT 10 22 DDNAME=SYS00001
20190614103020 RGT 10 23 DSN=OZRRACC.DSN04239.F1CRRFTG.FLP00001.RI056542
20190614103020 RGT 10 24 DSNU1038I 165 10:30:27.18 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=COPYTPL
20190614103020 RGT 10 25 DDNAME=SYS00002
20190614103020 RGT 10 26 DSN=OZRRACC.DSN04239.F1CRRFTG.FRP00001.RI056542
20190614103020 RGT 10 27 DSNU1387I -RRA 165 10:30:27.20 DSNUSITS - DATA SORT FOR SINGLE COLUMN COLGROUPS AVOIDED
20190614103020 RGT 10 28 DSNU3340I 165 10:30:27.21 DSNUGSRT - UTILITY PERFORMS DYNAMIC ALLOCATION OF SORT DISK SPACE
20190614103020 RGT 10 29 DSNU231I -RRA 165 10:30:27.62 DSNURBDC - DICTIONARY WITH 4096 ENTRIES HAS BEEN SUCCESSFULLY BUILT FROM 5223 ROWS FOR
20190614103020 RGT 10 30 TABLE SPACE DSN04239.F1CRRFTG
20190614103020 RGT 10 31 DSNU251I 165 10:30:27.64 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=12963 FOR TABLESPACE
20190614103020 RGT 10 32 DSN04239.F1CRRFTG PART 1
20190614103020 RGT 10 33 DSNU252I 165 10:30:27.64 DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=12963 FOR TABLESPACE
20190614103020 RGT 10 34 DSN04239.F1CRRFTG
20190614103020 RGT 10 35 DSNU250I 165 10:30:27.64 DSNUGSRT - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
20190614103020 RGT 10 36 DSNU3340I 165 10:30:27.70 DSNURPIB - UTILITY PERFORMS DYNAMIC ALLOCATION OF SORT DISK SPACE
20190614103020 RGT 10 37 DSNU3342I 165 10:30:27.89 DSNURPIB - NUMBER OF OPTIMAL SORT TASKS = 2, NUMBER OF ACTIVE SORT TASKS = 2
20190614103020 RGT 10 38 DSNU395I 165 10:30:27.89 DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 4
20190614103020 RGT 10 39 DSNU3345I 165 10:30:27.89 DSNURPIB - MAXIMUM UTILITY PARALLELISM IS 9 BASED ON NUMBER OF PARTITIONS, INDEXES AND
20190614103020 RGT 10 40 STATISTICS
20190614103020 RGT 10 41 DSNU397I 165 10:30:27.89 DSNURPIB - NUMBER OF TASKS CONSTRAINED BY CPUS TO 9
20190614103020 RGT 10 42 -DSNU017I 165 10:30:27.94 DSNUGSAT -UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40347'
20190614103020 RGT 10 43 CAUSE=X'00E40347'
20190614103020 RGT 10 44 -DSNU016I 165 10:30:27.95 DSNUGSAT -UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'
20190614103020 RGT 10 45 -DSNU017I 165 10:30:27.96 DSNUGSAT -UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40347'
20190614103020 RGT 10 46 CAUSE=X'00E40347'

z/OS syslog reports an S04E abend.

ICE185A 0 AN S04E ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHAS
ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0002
ICE201I A RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE751I 0 C5-I40658 C6-I35397 C7-I35397 C8-I40658 E4-I40658 C9-I35397 E5-I38877
ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED"
ICE250I 0 VISIThttp://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES A
ICE000I 0 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R2 - 11:34 ON THU M
SORT FIELDS=(00009.0,00054.0,A,00001.0,00007.0,A),FORMAT=BI,FILSZ=U0000000297172
RECORD TYPE=F,LENGTH=(00062,00062,00062)
OPTION MSGPRT=ALL,MSGDDN=UTPRIN02,MAINSIZE=MAX,USEWKDD,NOEQUALS,SORTDSW02
ICE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED
ICE089I 1 RRAUTIL .RRAUTIL . , INPUT LRECL = 62, TYPE = F

Reason code X'00E40347' is a generic abend of the main task, so based on the error message text the issue is likely with the DFSORT subtask.

• Db2 z/OS V11 and v12
• Netweaver AS ABAP any version compatible with the above Db2 releases.

S04E RC00E40347 STATISTICS COLGROUP RELOAD LOAD REPLACE , KBA , BC-DB-DB2 , DB2 for z/OS , BC-DB-DB2-DBA , DB2 for z/OS - Database administration , How To