DB2 - Problembeschreibung
Problem IT08414 | Status: Geschlossen |
SYSPROC.ADMIN_DROP_SCHEMA RETURNS SQL0478N WHEN THE SCHEMA HAS 'CREATED GLOBAL TEMPORARY TABLE (CGTT)' | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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 V10.5 users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.5 Fix Pack 7 or higher. * **************************************************************** | |
Local-Fix: | |
Drop the CGTT manually and run sysproc.admin_drop_schema | |
Lösung | |
Fixed in DB2 V10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.04.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |