DB2 FOR LUW / DB2FORLUW / B10 - 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: v11.1 m1 fp2                                     *
****************************************************************

Drop and recreate the view manually.

not known / see Local fix

forerunner  : IT16665 
follow-up : 

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

03.08.2017
09.10.2017
09.10.2017