PM54050: ABEND0C4 RC4 IN DSNX5XPD AT OFFSET0782 BECAUSE OF INVALID FUNCTION CODE WHILE PROCESSING XMLTABLE IN SELECT STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND 0C4 RC00000004 IN DSNX5XPD AT +0782 BECAUSE OF invalid
  FUNCTION CODE WHILE PROCESSING XMLTABLE IN SELECT STATEMENT
  Additional keywords : SQLXML SQLSELECT 00000004 DSNX5XPD+0782
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 9 or DB2 10 for z/OS users that use the  *
  *                 XMLTABLE function which contains a column    *
  *                 path expression with a context position      *
  *                 predicate or an fn:position function.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a column path expression in an     *
  *                      XMLTABLE function contains a context    *
  *                      position predicate or an fn:position    *
  *                      funtion, (for example, b 1  or          *
  *                      b fn:position() = 1 ),                  *
  *                      ABEND 0C4-00000004 may occur at         *
  *                      DSNXGRDS.DSNX5XPD+0782 or at            *
  *                      DSNXGRDS.DSNX5XQN+0A72 in DB2 9 for     *
  *                      z/OS (PTF level UK57323), and at        *
  *                      DSNXGRDS.DSNX5XPD+0BEA or at            *
  *                      DSNXGRDS.DSNX5XQN+09C4 in DB2 10        *
  *                      for z/OS (PTF level UK73139).           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following examples illustrate the problem:
  SELECT X.* FROM XMLTABLE('/a'
          PASSING XMLPARSE('<a><b>1</b><b>2</b></a>')
          COLUMNS
            B1  CHAR(3) PATH 'b 1 ') AS X
  WHERE X.B1 IS NOT NULL;
  
  SELECT X.* FROM XMLTABLE('/a'
          PASSING XMLPARSE('<a><b>1</b><b>2</b><c>1</c><d>1</d>')
          COLUMNS
            D1  CHAR(3) PATH 'd 1 ',
            C1  CHAR(3) PATH 'c 1 ',
            B1  CHAR(3) PATH 'b 1 ') AS X
  WHERE X.B1 IN (X.C1, X.D1) ;
  
  The above two queries have XMLTABLE which contains a column
  path expression with a context position predicate, and they have
  WHERE clause in which the SQL predicate can be pushed down into
  the row path expression of the XMLTABLE.
  ABEND 0C4-00000004 occurs at DSNXGRDS.DSNX5XPD+0782 in DB2 9 for
  z/OS (PTF level UK57323) and at DSNXGRDS.DSNX5XPD+0BEA in DB2
  10 for z/OS (PTF level UK73139) for the above two queries if
  this APAR is not applied.
  
  Additional keywords: SQLXMLTABLE SQLPREDPUSHDOWN XMLPREDPUSHDOWN
                       ABEND0C4
  

Problem conclusion

• DB2 code is modified to fix the ABEND 0C4 problem occurring
  when a column path expression in an XMLTABLE function contains
  a context position predicate or an fn:position function.
  

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:

  UK75475 UK75476

Modules/Macros

• DSNXQRWC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK75475

     UP12/01/31 P F201

• R910 PSY UK75476

     UP12/01/31 P F201

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.