PH36450: A QUERY MAY RETURN MORE ROWS COMPARED TO RUNNING IT IN DB2 FOR Z/OS OR USING V5 OF THE ACCELERATOR.

APAR status

• Closed as documentation error.

Error description

• A query may return more rows compared to running it in DB2 for
  z/OS or using V5 of the accelerator when the following
  conditions are satisfied:
  - the query has multiple inner joins using equality join
    predicates
  - the same columns from the same tables are repeatedly used in
    many of these equality join predicates
  - at least one such equality predicate involves a join between
    such a column and an expression.
  
  The underlying issue is in Db2wh and has been documented by APAR
  IT35198.
  
  Additional keywords:
  TS004260860 INCORROUT IT35198 wsdbu01458630
  

Local fix

Problem summary

• The root cause of the issue reported in this APAR is a bug
  in the Db2wh component which has been documented by APAR
  IT35198.
  The fix for IT35198 has been incorporated in the Db2wh
  engine (11.5.5.0 Build special_6558) that was incorporated in
  accelerator maintenance level 7.5.5.1.
  

Problem conclusion

• Upgrade your accelerator maintenance level to 7.5.5.1 or higher.
  

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

Applicable component levels