|
Problem IT08207
|
Status: Closed |
SYSPROC.ADMIN_DROP_SCHEMA RETURNS SQL0478N WHEN THE SCHEMA HAS 'CREATED GLOBAL TEMPORARY TABLE (CGTT)' |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| Solution |
Fixed in DB2 V9.7 Fix Pack 11. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.04.2015
07.10.2015
07.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
