DB2 FOR LUW / DB2FORLUW / B10 - DB2

$ db2 "select grantee from syscat.indexauth where
indname='TAB_COMP_INFO_PK' and CONTROLAUTH='Y'"

GRANTEE
----------------------------------------------------------------
--------
--------------------------------------------------------
X_USERNAME
DB2CCGU1

  2 record(s) selected.

DB2CCGU1 is the definer, so it got this permission
automatically.
However running db2look with -xd option is supposed to generate
the DDL for the original definer and it is not doing
so. It is generating the grant DDL for the grant which has been
executed explicitly.

$ db2look -d ccgidsu1 -xd | grep -i x_username
-- No userid was specified, db2look tries to use Environment
variable USER
-- USER is: DB2CCGU1
GRANT CONTROL ON INDEX "DBA     "."TAB_COMP_INFO_PK" TO USER
"X_username ";

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* GRANT CONTROL ON SPECIFIC OBJECTS TO the ORIGINAL DEFINER    *
****************************************************************

not known / see Local fix

forerunner  : IT17397 
follow-up : 

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

03.08.2017
10.10.2017
10.10.2017