DB2 - Problembeschreibung
Problem IC96483 | Status: Geschlossen |
IMPLEMENTATION FIELD IN SYSCAT.ROUTINES FOR A SOURCED FUNCTION MISSING MODULE NAME | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
The following examples display the behavior. Please note that this change was only shipped in DB2 10.5 Fixpack 4. This change is being rolled back to previous behavior via APAR IT04141 CREATE OR REPLACE FUNCTION R1.F1() SPECIFIC F1 RETURNS INT RETURN 1 DB20000I The SQL command completed successfully. CREATE OR REPLACE FUNCTION R1.F2 ( ) RETURNS INTEGER SOURCE R1.F1() DB20000I The SQL command completed successfully. CREATE OR REPLACE MODULE R1.M1 DB20000I The SQL command completed successfully. ALTER MODULE R1.M1 PUBLISH FUNCTION F1() SPECIFIC F1 RETURNS INT RETURN 1 DB20000I The SQL command completed successfully. CREATE OR REPLACE FUNCTION R1.F2M ( ) RETURNS INTEGER SOURCE R1.M1.F1() DB20000I The SQL command completed successfully. SELECT SUBSTR(ROUTINESCHEMA,1,5), SUBSTR(ROUTINENAME,1,5), SUBSTR(IMPLEMENTATION,1,10) FROM SYSCAT.ROUTINES WHERE ROUTINESCHEMA = 'R1' AND ROUTINENAME IN ('F2', 'F2M') 1 2 3 ----- ----- ---------- R1 F2 R1.F1 () R1 F2M R1.F1 () 2 record(s) selected. The second row should ready R1.M1.F1() for the IMPLEMENTATION. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * First changed in DB2 10.5 Fixpack 4 but this change is being * * rolled back to previous behavior via APAR IT04141 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
First changed in DB2 10.5 Fixpack 4 but this change is being rolled back to previous behavior via APAR IT04141 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 30.09.2013 02.09.2014 02.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |