DB2 FOR LUW / DB2FORLUW / A50 - 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.5 fixpack 3.                   * 
****************************************************************

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.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 10.5 Fixpack 3.

not known / see Local fix

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

27.08.2013
27.02.2014
27.02.2014