IBM Support

PM37641: DEFECT 149281. PROBLEM OCCURS WHEN RUNNING A V9 PACKAGE WITH NESTED XML FUNCTIONS ON V10. FUNCTIONS MIGHT BE SKIPPED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • defect 149281. problem occurs when running a V9 package with
    nested XML functions on V10. Functions might be skipped
    

Local fix

  • No Work Around
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of XMLCAST         *
    *                 bound in DB2 9 for z/OS                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: When running a DB2 V9 package which     *
    *                      contains an XMLCAST with another XML    *
    *                      function as the argument, ABEND0C7,     *
    *                      LOC=DSNXGRDS.DSNXRSN9+711C or incorrect *
    *                      output will occur.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When running a DB2 V9 package which contains an XMLCAST with
    another XML function as the argument, ABEND0C7,LOC=DSNXGRDS.
    DSNXRSN9+711C or incorrect output will occur.
    
    For example:
    In the following query, the XMLCAST has the XMLQUERY function as
    the argument:
    
    EXEC SQL
      SELECT
          SUM(
            XMLCAST(
              XMLQUERY('/a/b' PASSING XMLPARSE(DOCUMENT
                                '<a><b><c>567.89</c></b></a>'))
            AS DECIMAL(9,2)))
          INTO :AMOUNT
      FROM SYSIBM.SYSDUMMY1;
    
    If this query is bound in DB2 V9 and runs on DB2 V10, ABEND0C7,
    LOC=DSNXGRDS.DSNXRSN9+711C will occur because the XMLCAST was
    not executed.
    

Problem conclusion

  • DB2 is modified to ensure that the XMLCAST is executed.
    
    Additional Keyword: SQLXML SQLINCORR INCORROUT SQLINCORROUT
                        DB2INCORR/K XMLALL XMLINCORR
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM37641

  • 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

    2011-04-22

  • Closed date

    2011-06-28

  • Last modified date

    2011-08-01

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

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

    UK69247

Modules/Macros

  • DSNXRXM9
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK69247

       UP11/07/13 P F107

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 August 2011