DB2 FOR LUW / DB2FORLUW / A10 - DB2

Whenever invalid view is converted to statsview then explicitly 
re-validated (select * form v1) and dropped , orphans entries in 
catalog PD gets created and subsequent drop table will fail with 
901.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* move to v97fp7 , v101fp2                                     * 
****************************************************************

The key idea is to not convert an "invalid" view to a statsview. 
Hence, before altering a view to statsview, make sure it's valid 
with the below query: 
 
"select valid from syscat.views where viewschema = <schema> and 
viewname = <name>" 
 
If valid = Y, then continue with the ALTER VIEW statement. 
Otherwise, to revalidate an invalid view, e.g. view name AB.CD, 
customer may 
 
     call SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('view', 'AB' , 
'CD'); 
 
or 
 
    call SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('view', NULL, 
NULL); 
 
to revalidate all views. After regular view gets out of invalid 
state, it will be safe to be converted to statview by ALTER VIEW 
statement.

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

move to v97fp7 , v101fp2

not known / see Local fix

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

04.11.2012
09.01.2013
09.01.2013

9.7.FP7