DB2 - Problem description
Problem IT18849 | Status: Closed |
DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
When "PL/SQL support" is enabled, issuing DROP PACKAGE SYSname fails with SQLCODE -553, SQLSTATE 42939. SYSname is any identifier that begins with SYS. The following steps illustrate the problem. $ db2set DB2_COMPATIBILITY_VECTOR=800 $ db2stop $ db2start $ db2 connect to sample Database Connection Information Database server = DB2/AIX 10.5.7 SQL authorization ID = DB2INST1 Local database alias = SAMPLE $ db2 drop package NULLID.SYSLH303 SQL0553N An object cannot be created with the schema name "SYSLH302". LINE NUMBER=1. SQLSTATE=42939 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade Db2 to the latest release * **************************************************************** | |
Local Fix: | |
Use the synonym DROP PROGRAM. For example: db2 drop PROGRAM NULLID.SYSLH303 | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.01.2017 30.01.2020 30.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |