DB2 FOR LUW / DB2FORLUW / 970 - DB2

To calculate REORGCHK formula F4-F8, reorgchk calculates the 
average index record size and min key size for both leaf and 
non-leaf pages. While calculating average index record size, if 
any query failed to return any data; reorgchk stops processing 
for other indexes and moves on to next table. Reorgchk should 
continue processing for other indexes of the same table. 
 
This issue affect only the "REORGCHK" command. Under some 
circumstances, it is possible that the REORGCHK command might 
not evaluate all indexes defined for the table. 
 
If you are impacted by the issue, you can use the 
SYSPROC.REORGCHK_IX_STATS () function instead. 
 
Per example, if the command 
     db2 "REORGCHK CURRENT STATISTICS ON TABLE SAMPLE.MY_TABLE" 
 
returns only some of the indexes, you may use the function 
instead as follows: 
    db2 "CALL SYSPROC.REORGCHK_IX_STATS('T','SAMPLE.MY_TABLE')" 
 
The use of the function will return all indexes as it should.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All using REORGCHK command                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* To calculate REORGCHK formula F4-F8, reorgchk calculates the * 
* average index record size and min key size for both leaf and * 
* non-leaf pages. While calculating average index record size, * 
* if any query failed to return any data; reorgchk stops       * 
* processing for other indexes and moves on to next table.     * 
* Reorgchk should continue processing for other indexes of the * 
* same table.                                                  * 
*                                                              * 
* This issue affect only the "REORGCHK" command. Under some    * 
*                                                              * 
* circumstances, it is possible that the REORGCHK command      * 
* might                                                        * 
* not evaluate all indexes defined for the table.              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to version 9.7 fixpack 5                             * 
****************************************************************

Use CALL SYSPROC.REORGCHK_IX_STATS() instead of REORGCHK.

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 fixpack 5

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC85778 
Nachfolger : 

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

19.04.2011
13.12.2011
13.12.2011

9.7.FP5