PM94155: LOAD USING UNLOAD FORMAT SPANNED WITH XML COLUMN RELOADS A SINGLE ROW BACK TO THE TABLE DISCARDING TH 13/08/05 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LOAD using UNLOAD FORMAT SPANNED and table contains XML
  data type, reloads a single row discarding the rest of the
  rows.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users with               *
  *                 PM73034 (UK94806) using LOAD FORMAT          *
  *                 SPANNED YES.                                 *
  *                 All DB2 11 for z/OS users of LOAD FORMAT     *
  *                 SPANNED YES.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: On DB2 10 for z/OS with PM73034         *
  *                      (UK94806) and DB2 11 for z/OS,          *
  *                      LOAD FORMAT SPANNED YES with an XML     *
  *                      field only loaded the first record      *
  *                      from SYSREC.                            *
  *                      Also, LOAD FORMAT SPANNED YES did       *
  *                      not process NULLIF on a LOB field       *
  *                      correctly, resulting in no rows         *
  *                      loaded or abend ABEND0C4 RC00000004     *
  *                      at DSNURWRF +x'1052'.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  On DB2 10 for z/OS with PM73034 (UK94806) and DB2 11 for z/OS,
  LOAD FORMAT SPANNED YES incorrectly indexed to an XML field
  for all records after the first record in SYSREC.  Only the
  first record was processed correctly and loaded into the table.
  All subsequent records were discarded.
  
  
  LOAD FORMAT SPANNED YES did not process NULLIF on a LOB field
  correctly, resulting in no rows loaded or abend
  ABENDS0C4 DSNURWRF OFFSET1052 RC4.  This occurred when the
  NULLIF referred to a field or location which was not immediately
  before the LOB field in the VBS logical record.
  

Problem conclusion

• Modified LOAD FORMAT SPANNED YES functionality to correctly
  index XML fields for the case above.
  Modified LOAD FORMAT SPANNED YES functionality to correctly
  process NULLIF for LOB fields as described above.
  

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:

  UI12646 UI12647

Modules/Macros

• DSNURWRF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI12646

     UP13/12/05 P F312

• RB10 PSY UI12647

     UP13/12/05 P F312

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.