DB2 FOR LUW / DB2FORLUW / 970 - DB2

A query that may have been perfoming well prior to DB2 version 
9.7 fix pack 5 may stop choosing an index after upgrading to DB2 
version 9.7 fix packs 5 to 8.  This can happen on a VARCHAR2 
enabled database when the query includes basic predicates 
involving VARCHAR columns.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on version 9.7 fix packs 5 to 8                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 fix pack 9                        * 
****************************************************************

Use optimization guidelines to use the appropriate index, for 
example: 
 
SELECT... /* <OPTGUIDELINES> 
           <IXSCAN TABLE="A" INDEX="MYINDEX"/> 
     </OPTGUIDELINES> */

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 version 9.7 fix pack 9

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC96232 IC96236 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

23.07.2013
02.01.2014
02.01.2014

9.7.FP9