LI74177: ENABLE OUTER JOIN QUERY BEING ROUTED TO MQT WHICH HAS PREDICATE

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Description:
  DB2 used to not consider routing left or right OUTER JOIN query
  construct to MQT unless this MQT is SELECT FROM a base table
  without any predicate. This fix relax the constraint of no
  presence of any predicate. Since MQT is dependant on a single
  base table, the predicate must be local predicate.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users using DB2 v9.5 with fixpack lower than fixpack 5.      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DB                                                           *
  * 2 used to not consider routing left or right OUTER JOIN      *
  * query co                                                     *
  * nstruct to MQT unless this MQT is SELECT FROM a base table   *
  *  wi                                                          *
  * thout any predicate. This fix relax the constraint of no     *
  *  pr                                                          *
  * esence of any predicate. Since MQT is dependant on a single  *
  *  ba                                                          *
  * se table, the predicate must be local predicate.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to v9.5 fixpack 5                                    *
  ****************************************************************
  

Problem conclusion

• Fix included in v9.5 fixpack 5
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IZ43821

• APAR is sysrouted TO one or more of the following:

  IC61593

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R950 PSY

     UP