PI67742: ABEND0C4 RC04 DSNXOOS1 OFFSET44B0 CAN OCCUR FOR AN SQL STATEMENT THAT REFERENCES A VIEW COLUMN WITH XML DATA TYPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC04 DSNXOOS1 OFFSET44B0 can occur for an SQL
  statement that references a view column with an XML data type
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 10 or 11 for z/OS users of an SQL                    *
  * statement containing a view with an XML                      *
  * function and CTE or a table expression.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Abend could happen for an SQL                                *
  * statement satisfying all of the                              *
  * following conditions:                                        *
  * 1. It contains a view with a                                 *
  * materialized CTE or a materialized                           *
  * table expression.                                            *
  * 2. The view contains an XML function                         *
  * in the select list.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An example is shown below:
  
  CREATE TABLE T2 (C1 INT, C2 VARCHAR(50));
  
  CREATE VIEW V1 AS
  WITH CTE1(C1, C2, C3) AS
    (SELECT C3, C2, RAND() FROM T3)
  SELECT CTE1.C1, xmlquery('//Item' passing CTE1.C2 ) as C2
  FROM CTE1;
  
  SELECT * FROM V1;
  
  DB2 did not correctly process the aforementioned SQL statement
  and resulted in an ABEND.
  

Problem conclusion

• DB2 has been modified to correctly process the aforementioned
  SQL statement.
  
  Additional Keywords: SQLXML SQLVIEW SQLCTE SQLTABLEEXPR
  

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:

  UI41392

Modules/Macros

• DSNXOOS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI41392

     UP16/10/19 P F610

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.