DB2 - Problembeschreibung
Problem IC78245 | Status: Geschlossen |
ADMIN_DROP_SCHEMA FAILED WHEN ONLY INOPERATIVE OBJECTS EXIST IN A SCHEMA | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
When only inoperative objects exist in a schema, the stored procedure ADMIN_DROP_SCHEMA does not remove the schema and dependent objects correctly. Below is the script that creates a database and tests ADMIN_DROP_SCHEMA. It first creates a table and a view, then drops the table. This gives an error SQL0478N, and does not remove the view. --drop database tmp; create database tmp; connect to tmp; call sysproc.sysinstallobjects('DB2AC', 'C', null, null); create table sven.test(x integer not null, y integer); create view sven.v as select * from sven.test; drop table sven.test; call sysproc.admin_drop_schema('SVEN', null, 'E', 'E'); select * from e.e; list tables for schema sven; | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users using 97fp8 or below db2level can be affected * **************************************************************** * PROBLEM DESCRIPTION: * * When only inoperative objects exist in a schema, the stored * * procedure ADMIN_DROP_SCHEMA does not remove the schema and * * dependent objects correctly. * * * * Below is the script that creates a database and tests * * ADMIN_DROP_SCHEMA. It first creates a table and a view, then * * drops the table. This gives an error SQL0478N, and does not * * remove the view. * * * * --drop database tmp; * * create database tmp; * * connect to tmp; * * call sysproc.sysinstallobjects('DB2AC', 'C', null, null); * * create table sven.test(x integer not null, y integer); * * create view sven.v as select * from sven.test; * * drop table sven.test; * * call sysproc.admin_drop_schema('SVEN', null, 'E', 'E'); * * select * from e.e; * * list tables for schema sven; * **************************************************************** * RECOMMENDATION: * * Upgrade to 95fp9 * **************************************************************** | |
Local-Fix: | |
Drop underlying objects and the schema manually using corresponding DROP statements. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC78261 IC84137 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.08.2011 08.03.2012 08.03.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP9 | |
Problem behoben lt. FixList in der Version | |
9.5.0.9 |