DB2 FOR LUW / DB2FORLUW / 970 - DB2

If runstats is executed on a range partitioned table using the 
"FOR INDEXES" clause, existing partition statistics in 
syscat.datapartitions will be reset to 0. 
 
For example, executing runstats for only 1 index can be done as 
follows : 
 
runstats on table db2inst1.tab1 for detailed index db2inst1.idx1 
 
and the data partition statistics can be retrieved as follows : 
 
select substr(tabname,1,20) as 
tabname,card,npages,fpages,stats_time 
from syscat.datapartitions 
where tabname = 'TAB1' 
 
With this apar, the statistics will show 0 for columns card, 
npages and fpages. 
 
More examples of runstats executions that will have this problem 
: 
runstats on table db2inst1.tab1 for index db2inst1.idx1; 
runstats on table db2inst1.tab1 for detailed indexes all; 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the DB2 server to V9.7 Fix Pack 6                    * 
****************************************************************

Use the "AND INDEXES" clause, which will collect table 
statistics as well as index statistics. 
e.g. to correct example 1 : 
 
 
runstats on table db2inst1.tab1 AND detailed index 
db2inst1.idx1; 
 
Note this this will slow down runstats execution as table 
statistics are also gathered.

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 V9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

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

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

23.02.2012
22.06.2012
22.06.2012

9.7.FP6