DB2 FOR LUW / DB2FORLUW / A10 - DB2

Page fetch pairs statistics are collected when DETAILED index 
statistics are collected.  In a database with varchar2 
compatibility enabled, the PAGE_FETCH_PAIRS and 
AVGPARTITION_PAGE_FETCH_PAIRS statistics cannot be cleared by 
manual update of SYSSTAT.INDEXES. 
 
Typically, users might try to clear the statistics with either a 
zero-length string or a single blank string.   In both cases, 
DB2 will return an error, either SQL0407N or SQL1227N. 
 
You might experience this problem when trying to use db2look in 
mimic mode on a database with varchar2 compatibility enabled.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB  version 10.1 fixpack 4.                  * 
****************************************************************

To clear the index statistics, perform a runstats without 
DETAILED index statistics, for example, 
   RUNSTATS ON TABLE TEST.T1 WITH DISTRIBUTION AND INDEXES ALL 
 
If you have a -m db2look mimic output file you want to apply, 
1) replace the table-only runstats command with one that also 
collects basic index statistics 
2) replace PAGE_FETCH_PAIRS='' with PAGE_FETCH_PAIRS=' ' 
3) replace AVGPARTITION_PAGE_FETCH_PAIRS='' with 
AVGPARTITION_PAGE_FETCH_PAIRS=' ' 
 
For example, 
 
replace occurrences of: 
RUNSTATS ON TABLE "TEST    "."T3" ; 
    PAGE_FETCH_PAIRS='', 
    AVGPARTITION_PAGE_FETCH_PAIRS='', 
 
with: 
RUNSTATS ON TABLE "TEST    "."T3" AND INDEXES ALL ; 
    PAGE_FETCH_PAIRS=' ', 
    AVGPARTITION_PAGE_FETCH_PAIRS=' ',

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 10.1 FixPack 4.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.11.2013
09.06.2014
09.06.2014