|
Problem IT10962
|
Status: Closed |
DB21017E MAY BE RETURNED WHEN EXECUTING DESCRIBE INDEXES FOR TABLE SHOW DETAIL. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When executing the DB2 command DESCRIBE INDEXES FOR TABLE with
the option SHOW DETAIL you may experience DB21017E error if the
user executing "describe" is not the creator of the table and if
the user has not been granted necessary and required privileges.
e.g: Assuming the table was created as user1, describing the
indexes as user2 might result in the following error:
user2@chaplin:~[247]% db2 describe indexes for table
user1.foo show detail
Index
Index
Unique Number of Index Index
Null Index Data
Max Varchar Xml
BUSINESS_TIME Column
schema
name
rule columns type
partitioning keys ID type
Hashed Length pattern
WITHOUT OVERLAPS names
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
-------------- -------------- ---------------------------
-------------- ------ ---------------
----------------------------------------------------------------
----------------------------------------------------------------
------- ---------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------
--------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
----------------------------------------------------------------
DB21017E The Command Line Processor encountered a system error
with the
front-end process output queue. Reason code = -2029060033.
Instead of DB21017E the following message should be returned to
the user
SQL0551N "user2" does not have the privilege to perform
operation "SELECT"
on object "SYSCAT.INDEXCOLUSE".
To resolve the error GRANT SELECT privilege on
SYSCAT.INDEXCOLUSE to user USER2.
One can observe db2 traces to determine the table/view in error
and take correct action as per the error logged in traces. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* USERS EXECUTING DESCRIBE INDEXES FOR *
* TABLE SHOW DETAIL. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.5 FP7. *
**************************************************************** |
| Local Fix: |
GRANT SELECT privilege on SYSCAT.INDEXCOLUSE(or the table/view
in error) to user executing the describe. |
| Solution |
Upgrade to DB2 version 10.5 FP7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.08.2015
19.01.2016
19.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
