DB2 - Problem description
Problem IT35068 | Status: Closed |
DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - 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: * * See Local Fix * **************************************************************** | |
Local Fix: | |
Use the synonym DROP PROGRAM. For example: db2 drop PROGRAM NULLID.SYSLH303 | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See Local Fix * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.11.2020 05.10.2021 05.10.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |