home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT10962 Status: Geschlossen

DB21017E MAY BE RETURNED WHEN EXECUTING DESCRIBE INDEXES FOR TABLE SHOW
DETAIL.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.
Lösung
Upgrade to DB2 version 10.5 FP7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
28.08.2015
19.01.2016
19.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList