DB2 - Problem description
Problem IT19251 | Status: Closed |
CALLING A STORED PROCEDURE AGAINST NON-UDB SERVER RESULTS IN DB21102E | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
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). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.02.2017 23.06.2017 23.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |