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 IT03336 Status: Geschlossen

OBJECT CAN BE DROPPED, ALTERED, RENAMED OR TRUNCATED USING A SYNONYM IN AN
ORA MODE DATABASE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
In an ORA enabled database (DB2_COMPATIBILITY_VECTOR=ORA), an 
object can be dropped, altered, renamed or truncated using its 
synonym. 
For example: 
 
CREATE TABLE T (C1 INT); 
DB20000I  The SQL command completed successfully. 
 
CREATE SYNONYM S FOR TABLE T; 
DB20000I  The SQL command completed successfully. 
 
DROP TABLE S; 
DB20000I  The SQL command completed successfully. 
 
The DROP TABLE statement should fail in an ORA enabled database.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to 10.5 fp 5                                         * 
****************************************************************
Local-Fix:
Lösung
first fix in 10.5 fp 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.07.2014
20.03.2015
20.03.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList