DB2 FOR LUW / DB2FORLUW / B10 - DB2

When you run a procedure against a server of type non-UDB, for 
example DB2 zOS, the procedure may fail with DB21102E error. 
 
 
CREATE PROCEDURE P1 
DYNAMIC RESULT SETS 1 
BEGIN 
DECLARE cur CURSOR WITH RETURN TO CLIENT 
FOR 
SELECT IBMREQD FROM SYSIBM.SYSDUMMY1; 
OPEN cur; 
END 
 
DB20000I  The SQL command completed successfully. 
 
 
When you call the procedure P1 you should get the following 
result: 
 
$ db2 "call p1()? 
 
  Result set 1 
  -------------- 
  IBMREQD 
  ------- 
  Y 
 
  1 record(s) selected. 
 
When you try to call the procedure P1 against non-UDB server, 
the error appears: 
 
$ db2 "call p1()? 
 
DB21102E  Too many parameters were specified for stored 
procedure ?TEST.P1? 
(expected 0).

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               * 
****************************************************************

DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in DB2 11.1 Mod 2 Fix Pack 2

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

14.02.2017
23.06.2017
23.06.2017