PI67416: THIS APAR IS FORWARD FIT FOR V11 APAR PI64302

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• * PROBLEM DESCRIPTION: Infinite loop could happen for an       *
  
  
  *                      SQL statement satisfying all of the     *
  
  
  *                      following conditions:                   *
  
  
  *                      1. An index is created on the xml       *
  
  
  *                      column.                                 *
  
  
  *                      2. It contains an XMLTABLE function.    *
  
  
  *                      3. It contains a predicate that         *
  
  
  *                      reference the XMLTABLE column and       *
  
  
  *                      a special register.                     *
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 11 for z/OS users of an SQL statement containing an  *
  * XMLTABLE with a local predicate that references a special    *
  * register.                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Infinite loop could happen for an SQL statement satisfying   *
  * all of the following conditions:                             *
  *                                                              *
  *  1. An index is created on the xml column.                   *
  *                                                              *
  *  2. It contains an XMLTABLE function.    *                   *
  *                                                              *
  *  3. It contains a predicate that reference the XMLTABLE      *
  * column and a special register.                     *         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An example is shown below:
  
  
  
  
  
  CREATE TABLE T1 ( C1   BIGINT, C2   XML );
  
  
  CREATE INDEX IX01.T1
  
  
    ON T1 (C2)
  
  
      GENERATE KEY USING XMLPATTERN
  
  
         '//abc'
  
  
    AS SQL TIMESTAMP(12)
  
  
   ;
  
  
  
  
  
  SELECT S.C1
  
  
    FROM T1 AS S ,
  
  
         XMLTABLE('customer' PASSING S.C2
  
  
               COLUMNS  C1   TIMESTAMP PATH 'abc'
  
  
                  ) AS XT
  
  
     WHERE XT.C1 <= CURRENT TIMESTAMP
  
  
    ;
  
  
  
  
  
  DB2 did not correctly process the aforementioned SQL statement
  
  
        and resulted in an infinite loop and system outage.
  

Problem conclusion

• DB2 has been modified to correctly process the aforementioned
  
  
        SQL statement.
  
  
  
  
  
        Additional Keywords: SQLSPECIALREG SQLXML SQLPREDPUSHDOWN
  

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:

  UI44174

Modules/Macros

• DSNXOMCH DSNXOIDX DSNXQMCH DSNXOCXF DSNXOXRW
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI44174

     UP17/02/10 P F702

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.