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

RENAME TABLE AGAINST AN ALIAS CAUSES THE UNDERLYING TABLE TO TAKE ON THE
ALIAS' SCHEMA

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
For example, suppose table S1.T1 has an alias in a different 
schema, S2.T1_ALIAS. After 
 
rename table S2.T1_ALIAS to T1_NEW 
 
the underlying table is renamed to T1_NEW (this is expected), 
but the table's schema is changed to the alias' schema. S1.T1 no 
longer exists, as it's renamed to S2.T1_NEW, and the alias 
refers to a non-existent table (S1.T1). 
 
The underlying table's schema should remain unchanged.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 v9.7 Fix Pack 11                               * 
****************************************************************
Local-Fix:
N/A
Lösung
Problem first fixed in DB2 v9.7 Fix Pack 11
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.10.2014
19.10.2015
19.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList