DB2 FOR LUW / DB2FORLUW / 970 - DB2

When online reorg is in truncate phase, a simultaneous query 
using scan sharing could fail and return a SQL0901N error. The 
timing window for this error is small and this problem is not 
likely to occur. In the db2diag.log, an error message similar to 
the following will appear: 
 
2011-07-25-06.23.52.246691-240 I28169292E2704      LEVEL: Severe 
PID    : 8690                TID  : 140733533120256PROC : 
db2sysc 
INSTANCE: svtdbm2              NODE : 000          DB  : HADR975 
APPHDL  : 0-33180              APPID: 
*LOCAL.svtdbm2.110725181848 
AUTHID  : SVTDBM2 
EDUID  : 1613                EDUNAME: db2agent (HADR975) 
FUNCTION: DB2 UDB, data management, sqldFetch, probe:7848 
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR 
          "non-severe dms programming error" 
          DIA8532C An internal processing error has occurred. 
DATA #1 : String, 46 bytes 
sshScanStopPage >= sqldLastObjPage2ScanPreWrap 
DATA #2 : String, 9 bytes 
sqldfrd.C 
CALLSTCK: 
  [0] 0x00007FFFF13415FA pdLog + 0x18C 
  [1] 0x00007FFFF52708E1 sqlzSetAndLog901 + 0x395 
  [2] 0x00007FFFF19FB668 _Z7sqldfrdP13SQLD_DFM_WORK + 0x2084 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A scan sharing query could fail with SQL0901N when online    * 
* reorg is in truncate phase.                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 5.                              * 
****************************************************************

Re-run the query when online reorg is not in truncate phase.

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem was first fixed in DB2 V9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

14.08.2011
23.12.2011
23.12.2011

9.7.FP5