DB2 FOR LUW / DB2FORLUW / A10 - DB2

Calling ADMIN_DROP_SCHEMA will return -478 / SQL0478 in the 
error schema and error table in databases created with Oracle 
compatibility features enabled. 
 
To Reproduce: 
 
db2set DB2_COMPATIBILITY_VECTOR=ORA 
db2stop 
db2start 
 
/* Oracle compatibility must be enabled for this database */ 
db2 "create db test" 
 
db2 "connect to test" 
db2 "create table s.t(c1 int)" 
 
db2 "call sysproc.admin_drop_schema('S', NULL, 'E', 'E')" 
 
/* Select from the error schema and error table, this contains 
 * -478/SQL0478 error because the call to ADMIN_DROP_SCHEMA 
failed 
 */ 
 
db2 "select * from e.e" 
 
/* succeeds after the schema name is padded with 7 blanks */ 
db2 "call sysproc.admin_drop_schema('S       ', NULL, 'E', 'E')" 
 
db2 "terminate" 
db2stop

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of DB2                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 1 or higher             * 
****************************************************************

Pad the schema name with blanks if it is less than 8 characters. 
For example if the schema name is REX, then it should be padded 
with 5 blank chars so that the total length is 8 characters.

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 Version 10.1 Fix Pack1

keiner bekannt / siehe Local-Fix

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

13.06.2012
08.04.2013
08.04.2013