PM09227: LOAD UTILITY CAUSED VARIOUS ABENDS AND DB2 CRASH SMCOVERLAY DB2OVRLAY/K

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Various abends and DB2 crash can be caused by Load utility
  storage overlay.
  The known symptoms are:
    ABND=04E-00E20001 at DSNLCBFM.DSNSVBK +125Eand DB2 crashed
    ABND=04E-00D31011 at DSNLILLM.DSNLISKM:000A
    ABND=0C4-00000038 at DSNSLD4 .DSNSVSGM+08D8 and DB2 crashed
  ABND=0C4-00000038 at DSNLILLM.DSNLQACT+17D0
  ABND=DC2-69004521 at DSNSVSFM,PSW=070C5000816FCC34
    ABENDDC2, ABEND0C4, RC00E20001, RC00D31011, SMCOVERLAY
  DB2OVRLAY/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS utility users of LOAD     *
  *                 with delimited input data.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABENDSDC2 DSNSVSFM during a LOAD FORMAT *
  *                      DELIMITED utility with no COLDEL        *
  *                      specified with input data delimited by  *
  *                      a non-default character.                *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A LOAD FORMAT DELIMITED utility abended with an ABENDDC2
  DSNSVSFM due to a storage overlay.  The input data was delimited
  with a column delimiter (COLDEL) of x'A1' but the LOAD statement
  did not include COLDEL x'A1', and parsed the delimited data
  looking for the default column delimiter (comma (,)). The
  delimited input data also contained garbage data past the last
  column.
  
  LOAD FORMAT DELIMITED parsed the input data looking for the
  default column delimiter, which it did not locate.  This caused
  LOAD to think all of the data in the input row was for the first
  column.  When there appeared to be no data for any of the other
  columns, a default NULL value was included.  This increased
  the size of the row to a length greater than what could fit in
  the buffer, overlaying storage.
  
  The storage overlay caused by LOAD resulted in various abends,
  including: ABEND04E RC00E20001 DSNSVBK +x'125E'; ABEND04E
  RC00D31011 DSNLISKM:000A; ABEND0C4 DSNSVSGM +x'08D8'
  

Problem conclusion

• Code has been added to check the length of the data row built
  by LOAD from the delimited input data when placing NULL values
  for columns not included in the input data.
  

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:

  UK56745

Modules/Macros

• DSNURILD DSNURLID DSNURPLD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK56745

     UP10/05/28 P F005

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.