DB2 FOR LUW / DB2FORLUW / A10 - DB2

When a view: 
 
a) is dependent on another view which is replaced with an MQT or 
   table thus invalidating it 
 
and 
 
b) makes use of a UDF 
 
During revalidation the SQL text of the view may be corrupted 
preventing the revalidation from completing. 
 
This occurs whether SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS or 
direct view access drives the revalidation. 
 
Direct revalidation will typically raise an SQL0104N error and 
SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS will report an SQL0361W 
warning, however in the SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS case 
the view text in SYSCAT.VIEWS is corrupted too (this does not 
occur with direct access revalidation). 
 
The corruption is of the last 8 bytes of the complete statement 
text as submitted so a comment at the end of the SQL may be all 
that is corrupted, if such a comment exists; revalidation will 
not report an error in this situation.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 Fix Pack 6                               * 
****************************************************************

Drop and recreate the view manually.

First fixed in DB2 10.1 Fix Pack 6

not known / see Local fix

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

18.08.2016
02.03.2017
02.03.2017