DB2 FOR LUW / DB2FORLUW / 970 - DB2

LOAD utility may set a row bit in an untimely fashion, causing 
index scan to skip that row and return incorrect results. 
 
The following sequence of events may cause the problem: 
 
- A load has been done some time in the past (could be years 
  ago) and has loaded rowA, and set the LOAD bit which was not 
  unset after the LOAD was done. 
- An index scan starts 
- A new load starts 
- The index scan attempts to fetch a key, and it sees the key 
  for rowA, which still has the LOAD bit set. 
 
As a result, the scan will incorrectly skip rowA and carry on 
without returning it.

A problem has been found in the code which allowed index 
scan and concurrent load operation to interfere with each 
other such that LOAD bit was not unser following a load, 
causing incorrect result to be returned by the scan.

n/a

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem has been corrected such that index manager will 
track when load operation is in progress in the affected 
index scan code path. This will allow index manager to 
accurately decide whether to include particular row into scan 
results while load is running. 
 
After the fix is applied, future loads will not cause this 
problem because index manager will handle it. Also, the fix 
provides correct querying capability to data previously loaded 
which may have the LOAD bit set.

keiner bekannt / siehe Local-Fix

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

20.07.2009
08.12.2009
08.12.2009