| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
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 |
|
