DB2 FOR LUW / DB2FORLUW / 970 - DB2

The command 
"db2 reorgchk current statistics on table all " 
on very large databases such as SAP databases involving 
thousands of tables and associated indexes can take a long time 
(more than 48 hours) to complete.   The same command on v9.5 
version will complete in hours. 
 
One of the underlying queries involved in the reorgchk logic has 
been identified as inefficient.  Reorgchk logic to get column 
IDs for Indexes in changed to return all the column IDs in one 
attempt with fewer joins.

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

N/A

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
 

First Fixed in Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

14.02.2011
19.12.2011
19.12.2011

9.7.FP5