DB2 FOR LUW / DB2FORLUW / A50 - DB2

If you have a view with comments on its columns and this view 
becomes invalid, the revalidation of the view will delete 
these comments. The comments on the view itself are not 
impacted. 
 
 
Example : 
 
create table t1 (c1 integer, c2 varchar(10)) 
DB20000I  The SQL command completed successfully. 
 
create or replace view v1(c1,c2) as select c1, c2 from t1 with 
no row movement 
DB20000I  The SQL command completed successfully. 
 
comment on column  v1.c1 is 'Remark:Column1' 
DB20000I  The SQL command completed successfully. 
 
comment on column  v1.c2 is  'Remark: Column2' 
DB20000I  The SQL command completed successfully. 
 
 
select remarks from syscat.columns where tabname='V1' 
 
REMARKS 
---------------------------------------------------------------- 
---------------- 
---------------------------------------------------------------- 
---------------- 
---------------------------------------------------------------- 
---------------- 
-------------- 
Remark:Column1 
Remark: Column2 
 
  2 record(s) selected. 
 
 
drop table t1 
DB20000I  The SQL command completed successfully. 
 
create table t1 (c1 integer, c2 varchar(10)) 
DB20000I  The SQL command completed successfully. 
 
select remarks from syscat.columns where tabname='V1' 
 
REMARKS 
---------------------------------------------------------------- 
---------------- 
---------------------------------------------------------------- 
---------------- 
---------------------------------------------------------------- 
---------------- 
-------------- 
Remark:Column1 
Remark: Column2 
 
  2 record(s) selected. 
 
 
call sysproc.admin_revalidate_db_objects ('VIEW', NULL,'V1') 
 
  Return Status = 0 
 
select remarks from syscat.columns where tabname='V1' 
 
REMARKS 
---------------------------------------------------------------- 
---------------- 
---------------------------------------------------------------- 
---------------- 
---------------------------------------------------------------- 
---------------- 
-------------- 
- 
- 
  2 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

Extract the view column comments DDL using db2look so it can be 
executed after view revalidation

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

08.02.2017
29.09.2017
29.09.2017

9.0.