PM77557: LOAD UTILITY PROCESS THE VARGRAPHIC COLUMN INCORRECTLY WHEN THE INPUT IS DELIMITED UTF-16 FILE AND THE DATA IS A NULL FOR COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LOAD utility process the VARGRAPHIC column incorrectly when the
  input is delimited UTF-16 file and the data is a NULL for
  column.
  

Local fix

• Do not use delimited file to load.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
  *                 users of the LOAD utility with delimited     *
  *                 input and vargraphic unicode columns.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 V9 ABEND04E RC00E20005 DSNSVBK   *
  *                      OFFSET09AC and in DB2 V10 ABENDS0C4     *
  *                      DSNSCON2 OFFSET15A4 when using the      *
  *                      LOAD utility with delimited input       *
  *                      on a unicode table with nullable        *
  *                      vargraphic columns.                     *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A LOAD DATA FORMAT DELIMITED on a unicode table with a nullable
  vargraphic column abended with an ABEND04E RC00E20005 DSNSVBK
  +x'09AC' (V9) or an ABEND0C4 DSNSCON2 +x'15A4' (V10).  The LOAD
  utility was interpreting the length of the nullable vargraphic
  field incorrectly because it was not recognizing the delimited
  input data, causing a storage overlay.  In some cases, the
  overlay caused DB2 to crash with MSGDSNV086E RC00D94001.
  
  Additional Keywords:  DB2OVRLAY/K DB2OVRLAY/M
  

Problem conclusion

• Code has been modified to correctly process delimited data
  for nullable vargraphic columns in a unicode table.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK90674 UK90675

Modules/Macros

•    DSNURWBG
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK90674

     UP13/01/17 P F301

• R910 PSY UK90675

     UP13/01/17 P F301

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.