|
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) |
