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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM77557

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-22

  • Closed date

    2012-12-31

  • Last modified date

    2013-02-04

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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM77557

Modified date:

2013-02-04

Translate my page

Machine Translation

Content navigation