DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V10.1 users                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 Fix Pack 5 or higher.                   * 
****************************************************************

Drop the CGTT manually and run sysproc.admin_drop_schema

Fixed in DB2 V10.1 Fix Pack 5.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

07.04.2015
14.07.2015
14.07.2015