PM72364: LOAD DUMMY ABEND REASON X'00E40070'WITH MESSAGE DSNU037I RECFM=U

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LOAD statement:
  LOAD DATA LOG YES ERRDDN(TSYSERR) WORKDDN(TSYSUT1, SORTOUT)
  MAPDDN(TSYSMAP)
     INTO TABLE DB2PRD.TATULZ_SDO_LJ_BX DISCARDDN(TSYSDISC) PART 7
  REPLACE INDDN SYSREC00
  
  TSYSDISC is defined as:
  //DB2UPROC.TSYSDISC DD SPACE=(TRK,1)
  
  SYSREC00 is defined as:
  //DB2UPROC.SYSREC00 DD DUMMY
  
  LOAD jog abend with x'00E40070':
  ...
  DSNU037I    240 07:34:50.70 DSNUGSDA - RECFM=U FOR DDNAME
  TSYSDISC
  DSNU016I    240 07:34:50.71 DSNUGBAC - UTILITY BATCH MEMORY
  EXECUTION ABENDED, REASON=X'00E40070'
  .
  Other symptom:
  If customer removes the DD SYSDISC and uses the TEMPLATE as
  following:
  
  TEMPLATE  TSYSDISC DSN 'SAMPL.&TS..P&PA..&UN..TSYSDISC'
  UNIT SYSDA SPACE TRK DISP (MOD,CATLG,CATLG) MAXPRIME 20000
  
  The LOAD jog abend with SC03.
  DSNU1036I   253 19:24:07.19 DSNURELD - UNABLE TO ESTIMATE SPACE
  REQUIREMENTS FOR  DISCARDDN
  DSNU012I    253 19:24:07.20 DSNUGBAC - UTILITY EXECUTION
  TERMINATED, HIGHEST RETURN CODE=8
  

Local fix

• Add DCB=RECFM=FB on //SYSDISC DD SPACE=(TRK,1)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
  *                 utility users of LOAD INTO TABLE PART with   *
  *                 SYSREC DD DUMMY                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGDSNU037I followed by ABEND04E        *
  *                      RC00E40070 or MSGDSNU1036I followed by  *
  *                      ABENDSC03 during a LOAD INTO TABLE PART *
  *                      with SYSREC defined as DD DUMMY and a   *
  *                      DISCARD data set defined with no SPACE  *
  *                      or RECFM attributes                     *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A LOAD INTO TABLE PART n INDDN SYSRECnn DISCARDDN DISCARDnn
  statement when partition parallelism is active ran with a DD
  DUMMY SYSREC data set. Message DSNU037I - RECFM=U FOR DDNAME
  SYSDISC was issued and followed by an ABEND04E RC00E40070 when
  the DISCARD data set was defined with no RECFM attributes.
  Message DSNU1036I- UNABLE TO ESTIMATE SPACE REQUIREMENTS FOR
  DISCARDDN was issued and followed by an ABENDC03 when TEMPLATE
  was used for the DISCARD data set with no SPACE attribute.
  
  The problem happened because a local flag for the DUMMY SYSREC
  was not set correctly. LOAD should tolerate the SYSREC DD DUMMY.
  
  The same problem may happened for other data sets during a
  partition parallelism load with one of DD DUMMY SYSREC.
  

Problem conclusion

• LOAD partition parallelism code has been modified to correct
  the reported problem.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK83899 UK83900

Modules/Macros

• DSNURELD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK83899

     UP12/12/18 P F212

• R910 PSY UK83900

     UP12/12/18 P F212

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.