IT34104: DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN

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 hang when the following conditions are met:
  
  -The query has inner join with OR predicate
  -At least one of the OR predicate references only one
  join/subgraph.
  

Local fix

• Turn the registry off:
  db2set -im DB2_EXTENDED_OPTIMIZATION="INJ_DUMMY_PRD4JOIN OFF"
  
  or apply the above using optimizer guidelines as
  
  <query>
  
  /*
  <OPTGUIDELINES>
  <REGISTRY>
  <OPTION NAME='DB2_EXTENDED_OPTIMIZATION'
  VALUE='INJ_DUMMY_PRD4JOIN OFF'/>
  </REGISTRY>
  </OPTGUIDELINES>*/ ;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 V11.1.4                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * none                                                         *
  ****************************************************************
  

Problem conclusion

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:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP