PM08749: ALLOW JOIN PREDICATES WITH DATA TYPE MISMATCHES TO BE CONSIDERED STAGE 1 WITH XMLTABLE WHEN THE INNER TABLE IS A BASE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ALLOW JOIN PREDICATES WITH DATA TYPE MISMATCHES TO BE CONSIDERED
  STAGE 1 WITH XMLTABLE WHEN THE INNER TABLE IS A BASE TABLE
  .
  SQLPERFORMANCE SQLACCESSPATH
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: For all DB2 for z/OS users who have a        *
  *                 predicate containing mismatched datatypes,   *
  *                 and such predicate also involves a column    *
  *                 from XMLTABLE(function).                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: For a predicate T1.C1=TX.C1, in which   *
  *                      T1 is a base table and TX is an         *
  *                      XMLTABLE(function), if T1.C1 and TX.C1  *
  *                      are of different datatypes, then the    *
  *                      predicate is always evaluated as        *
  *                      residual.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For the described predicate, when base table T1 is chosen as the
  inner table of a join, it should have DB2 type promotion support
  so that most of such predicates can be sargable and indexable.
  Such support is not available when XMLTABLE(function) is chosen
  as the inner table of a join. When XMLTABLE(function) is joined
  as the inner table, the predicate will remain as residual.
  
  Additional Keywords:
  SQLXML
  

Problem conclusion

• In conclusion, predicate T1.C1=TX.C1 where T1 is a base table
  and TX is an XMLTABLE(function), if T1.C1 and TX.C1 are of
  mismatched datatypes, the predicate can be made sargable and
  indexable when base table T1 is joined as the inner table.
  The predicate remains as residual when XMLTABLE(function) TX
  is joined as the inner table.
  

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:

  UK55648

Modules/Macros

• DSNXOCAT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK55648

     UP10/04/15 P F004

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.