DB2 FOR LUW / DB2FORLUW / A50 - DB2

Db2 may generate 901 with Reason "inconsistent QPDs for this
XPR", when the following conditions are met:

o There is one MQT defined.
o The query has join on multiple tables
o Along with other table(s), we have mqt table and xml table

Standalone repro:

create table t(c1 XML);
create table t1(c1 int not null  primary key);
create table t2(c1 char(3));
create table t3(t3c1 int, t3c2 int);

CREATE TABLE
    m AS
    (
        SELECT
            t1.c1
        FROM
            t1  )
    DATA INITIALLY  DEFERRED REFRESH IMMEDIATE;

SET INTEGRITY FOR m IMMEDIATE CHECKED NOT INCREMENTAL;

FLUSH PACKAGE CACHE DYNAMIC;

select t1.c1
from  ( select c1 from t)t
      ,      (SELECT c1 FROM t1 ) t1
      ,      XMLTABLE( '$ds/RBdocument' PASSING t.c1 AS "ds"
COLUMNS c CHAR(3) PATH 'c' ) AS x
      ,     t2 where      t2.c1 = x.c
;

****************************************************************
* USERS AFFECTED:                                              *
* All A50 users                                                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* To be fixed in 11.1 and above.                               *
****************************************************************

db2set DB2_COMPILER_XML_OVERRIDES=1
db2stop
db2start

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.07.2019
10.03.2020
10.03.2020