|
Problem IT08207
|
Status: Geschlossen |
SYSPROC.ADMIN_DROP_SCHEMA RETURNS SQL0478N WHEN THE SCHEMA HAS 'CREATED GLOBAL TEMPORARY TABLE (CGTT)' |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
SYSPROC.ADMIN_DROP_SCHEMA fails to drop the schema when the
schema has 'Created global temporary table (CGTT)'.
If the schema has regular table, admin_drop_schema automatically
drops the table and drops the schema.
If it has 'Created global temporary table (CGTT)', it fails
with:
SQL0478N DROP, ALTER, TRANSFER OWNERSHIP
or REVOKE on object type "SCHEMA" cannot be processed because
there is
an object "MYSCHEMA.TABLE1", of type "CREATED TEMPORARY
TABLE", which
depends on it. SQLSTATE=42893 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All DB2 V9.7 users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fix Pack 11 or higher. *
**************************************************************** |
| Local-Fix: |
Drop the CGTT manually and run sysproc.admin_drop_schema |
| Lösung |
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:
| 09.04.2015
07.10.2015
07.10.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP11
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.11
|
 |
