DB2 FOR LUW / DB2FORLUW / A50 - DB2

Automatic Table Maintenance failed to reorg some indexes which 
exceeded F4 and F5 formula when DB2_WORKLOAD=SAP is set. 
 
In db2diag.log you might see REORG started messages: 
 
2013-01-10-08.00.00.681617+060 I125863A374        LEVEL: Event 
PID     : 60359078             TID  : 1177        PROC : db2acd 
0 
INSTANCE: db2inst1               NODE : 000 
EDUID   : 1177                 EDUNAME: db2acd 0 
FUNCTION: DB2 UDB, Automatic Table Maintenance, 
db2AutoReorgExec, probe:10 
START   : Automatic reorg has started on table DB1     ."SAP 
"."DB6HISTBS" 
 
but there is never a matching ' Automatic reorg has completed 
successfully on table ...' and also no sign of an error. 
You will see such tables will be repeatable scheduled for 
automatic reorg.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4.                      * 
****************************************************************

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.5 Fix Pack 4.

keiner bekannt / siehe Local-Fix

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

27.08.2013
09.09.2014
09.09.2014