DB2 FOR LUW / DB2FORLUW / 970 - DB2

There is a potential inconsistency in the catalog tables which 
can cause database migration to DB2 v10.1 to fail. 
This inconsistency is a mismatch in SYSIBM.SYSTABLES between the 
STATS_PROFILE column and the information stored in the Packed 
Descriptor, if a table has  a runstats statistic profiles 
stored. 
 
So far this has only been reported for statistal views (a.k.a 
STATVIEWs). We need to provide a check utility (like db2cat -v) 
for this inconsistency that can be done pre-migration to avoid 
migration to a later DB2 version to fail.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.7 Fix Pack 8                    * 
****************************************************************

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 DB2 UDB Version 9.7 Fix Pack 8

keiner bekannt / siehe Local-Fix

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

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

22.10.2012
08.04.2013
08.04.2013

9.7.FP8