IBM Support

PM86927: FIX FOR DSNTIAUL TO SUPPORT UNLOADING XML DATA

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Currently DSNTIAUL unloads XML data as a CLOB and in this
    format, can not be loaded with DB2 Load utility. LOAD expects
    XML to have a 2-byte length field and a CLOB has a 4-byte
    length field.  This APAR will fix this so XML data is unloaded
    as XML data.
    

Local fix

  • use LOB file references
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DSNTIAUL in DB2 Version 9 and   *
    *                 DB2 Version 10 and DB2 Version 11 for z/OS   *
    *                 are affected by this change.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: Users of DSNTIAUL may observe that it   *
    *                      unloads XML columns as CLOB when the    *
    *                      LOBFILE parameter is not specified.     *
    *                      This can cause the DB2 LOAD utility to  *
    *                      terminate with return code 8 and this   *
    *                      message:                                *
    *                                                              *
    *                       DSNU390I -DSN1 hh:mm:ss.nn DSNURWUF -  *
    *                                INVALID CONVERSION FOR FIELD  *
    *                                -  field-name                 *
    *                      where field-name is the name of an XML  *
    *                      column in the table being loaded.       *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DSNTIAUL is a sample dynamic SQL processing application that is
    used primarily to unload data from DB2 tables to an externalized
    format.  DSNTIAUL also generates a LOAD control statement that
    can be used in conjunction with the DB2 LOAD utility to load the
    externalized data back into DB2.
    
    If the LOBFILE option is specified in the DSNTIAUL parameter
    list, data in XML columns is fully unloaded into CLOB reference
    files.  Otherwise, data in XML columns, up to 32 KB per row, is
    unloaded in record format and indicated as CLOB the generated
    LOAD statement.  However, the LOAD utility does not support
    loading XML columns from input record fields specified as CLOB;
    it fails with the symptoms noted in the problem description.
    

Problem conclusion

  • In response, this APAR modifies DSNTIAUL to provide a load
    statement to load XML data as XML when the LOBFILE option is
    not specified.
    

Temporary fix

Comments

  • ž**** PE14/08/20 FIX IN ERROR. SEE APAR PI22421  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PM86927

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-12

  • Closed date

    2014-05-15

  • Last modified date

    2014-11-18

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

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

    UI18014 UI18015 UI18016

Modules/Macros

  • DSNTIAUL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI18014

       UP14/05/30 P F405

  • RB10 PSY UI18015

       UP14/05/30 P F405

  • R910 PSY UI18016

       UP14/05/30 P F405

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.



Document information

More support for: DB2 for z/OS

Software version: 9.1

Reference #: PM86927

Modified date: 18 November 2014