PM25036: ABEND04E RC00E70005 AT DSNXRXML:P018 WHEN ACCESSING XML DATA IN A COEXISTENCE ENVIRONMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RDNA,ABND=04E-00E70005,U=XGGWSAD ,M=C9
  ,C=101.LOCN=::10.64.255.51   ,LOC=DSNXGRDS.DSNXRXML:P018
  
  occurred when accessing XML data in V9 - V10
  coexistence mode.
  

Local fix

• Rebind the package on V10
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of the XMLTABLE    *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 at DSNXRXML P018 *
  *                      can occur when running a DB2 9 for z/OS *
  *                      package with the XMLTABLE function on   *
  *                      DB2 10 for z/OS.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E70005 can occur at location DSNXRXML:P018 when
  running a DB2 V9 package that contains the XMLTABLE function on
  DB2 V10.
  
  For example, the following query contains the XMLTABLE function.
  
    SELECT X.*
    FROM XMLTABLE('/a/b'
           PASSING XMLPARSE('<a><b>11</b><b>22</b><b>33</b></a>')
           COLUMNS C1 VARCHAR(6) PATH '.') X;
  
  If a package with this query is bound on DB2 V9, then after
  migrating to DB2 V10, the above abend can occur when executing
  this package.
  

Problem conclusion

• DB2 is modified to process a DB2 V9 package with the XMLTABLE
  function properly.
  
  Additional Keywords: OFFSETP018 SQLXML
  

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:

  UK62983

Modules/Macros

• DSNXRBN9 DSNXRXML
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK62983

     UP10/12/28 P F012

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.