IT31145: CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES(RANGE AND OR PREDICATES)

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Db2 query may show poor performance for queries having CDE
  tables since HASH join is not picked up for joins having OR
  predicate or range predicate and there is no equality predicate.
  

Local fix

• Add dummy equality predicate to the query:
  nvl(mod(length(t1.col1),1),0) = nvl(mod(length(t2.col1),1),0)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

  IT31140

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSY

     UP