DB2 - Problembeschreibung
Problem IC80979 | Status: Geschlossen |
WHEN CREATE PACKAGE BODY GETS ERROR SQL20481N, THE ERROR MESSAGE DOES NOT IDENTIFY THE PROCEDURE THAT REFERENCES ITSELF. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When you run the CREATE PACKAGE BODY command for a package body that contains a procedure that references itself (whether directly or indirectly), it gets an error of the following form. SQL20481N The creation or revalidation of object "<object-name>" would result in an invalid direct or indirect self-reference. The "<object-name>" in the error message is the specific name and not the real name of the procedure. Because the package creation has failed due to the SQL20481N error, the specific name does not persist in the DB2 system catalog, so it is not possible find the real name of the procedure. With this APAR fix the "<object-name>" in the error message is the real name of the procedure. The following script demonstrates the problem. <code> create or replace package test_self_reference as procedure proc1; end@ create or replace procedure proc2 is begin test_self_reference.proc1(); end@ create or replace package body test_self_reference is procedure proc1 is begin proc2(); end proc1; end@ </code> Because of this defect the CREATE OR REPLACE PACKAGE BODY statement gets an error like this. SQL20481N The creation or revalidation of object "<schema-name>.TEST_SELF_REFERENCE.SQL120119100237800" would result in an invalid direct or indirect self-reference. With this APAR fix the CREATE OR REPLACE PACKAGE BODY gets an error like this instead. SQL20481N The creation or revalidation of object "<schema-name>.TEST_SELF_REFERENCE.PROC1" would result in an invalid direct or indirect self-reference. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of DB2 for Linux, UNIX and Windows * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * . * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.7 Fix Pack 6. At a minimum, this fix should be applied on the database server. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84312 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.01.2012 12.06.2012 12.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |