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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM94155

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-30

  • Closed date

    2013-11-18

  • Last modified date

    2014-01-02

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM94155

Modified date:

2014-01-02

Translate my page

Machine Translation

Content navigation