IZ26552: QUERY PERFORMANCE PROBLEM IF THERE ARE 200 ELEMENTS IN LIST

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
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

• INLIST to JOIN transform does not occur if there are exactly 200
  elements in the IN LIST , leading to a performance degradation
  for the query.
  

Local fix

• Use optimizataion level 7
  

Problem summary

• Users Affected:
  Db2 Users running a query with exactly 200 elements in an IN
  LIST.
  Problem Description:
  INLIST to JOIN transform does not occur if there are exactly 200
  elements in the IN LIST , leading to a performance degradation
  for the query.
  Problem Summary:
  Performance problem with IN LIST using 200 elements
  

Problem conclusion

• Problem first fixed in DB2 V9.5 FP2
  

Temporary fix

Comments

APAR Information

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

  IZ13205

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

Fix information

• Fixed component name

  DB2 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels

• R950 PSY

     UP