IZ55987: DYNAMIC SQL STATEMENTS WITH HOST VARIABLES, USING A REOPT ALWAYS OPTIMIZER GUIDELINE, MAY RETURN WRONG RESULTS

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

• Applying the REOPT optimizer guideline with VALUE='ALWAYS' to a
  dynamic SQL statement containing host variables may return wrong
  results.
  The following is an example of a REOPT ALWAYS guideline:
  <OPTGUIDELINES><REOPT VALUE='ALWAYS' /> </OPTGUIDELINES>
  
  REOPT VALUE='ONCE' works as expected.
  

Local fix

Problem summary

• USERS AFFECTED:
  All
  
  PROBLEM DESCRIPTION:
  See ERROR DESCRIPTION
  
  PROBLEM SUMMARY:
  See ERROR DESCRIPTION
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 5
  

Temporary fix

Comments

APAR Information

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

  IZ55549

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

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP

• R910 PSN

     UP

• R950 PSN

     UP