DB2 FOR LUW / DB2FORLUW / A10 - DB2

The following examples display the behavior.   Please note that 
this APAR was incorrectly raised and included in DB2 10.1 
Fixpack 4 and is being cancelled through IT03012 
 
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 read R1.M1.F1() for the IMPLEMENTATION.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First changed in DB2 10.1 Fixpack 4 but this change is being * 
* rolled back to previous behavior via APAR IT03012            * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First changed in DB2 10.1 Fixpack 4 but this change is being 
rolled back to previous behavior via APAR IT03012

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.10.2013
08.07.2014
09.07.2014