DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 Fix Pack 9.                       * 
****************************************************************

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: IC94959 IC95518 
Nachfolger : 

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

22.01.2013
17.12.2013
17.12.2013

9.7.FP9