IT11604: INDEX SCAN ON A DATA PARTITIONED TABLE MAY TRAP OR RETURN INCORRECT RESULTS IF PARTITIONS BECOME AVAILABLE DURING THE SCAN

DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• An index scan on a data partitioned table may trap or return in
  correct results if there were no available partitions when the
  scan was started, but a partition becomes visible (via a SET
  INTEGRITY command) before the scan completes.
  
  If there are no visible partitions when a partitioned index scan
  is started, the scan is expected to return no rows on fetch.
  Due to an error, if a data partition becomes visible during the
  scan,
   we will attempt to retrieve data and the wrong rows may be
  returned, predicates may be ignored, data rows may be returned
  out of order, or other unexpected errors may occur.
  
  If the index scan is using an index on expression, the attempt
  to retrieve data may trap.
  

Local fix

• Run SET INTEGRITY on newly attached partitions before detaching
  the last existing partition, or run SET INTEGRITY with the ALLOW
  NO ACCESS option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 10.1 Fix Pack 6                               *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 10.1 Fix Pack 6
  

Temporary fix

Comments

APAR Information

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

  IT09085

• 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