|
Problem IT38927
|
Status: Closed |
FEDERATION OVERLOADED PROCEDURE FAIL WITH SQL0901 RC = -2144272209=SQLNN_E_BADNEWS
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Federation drda wrapper procedure unique id support for zOS Db2
Customer has two overloaded procedures on zos. They are
accessing the overloaded procedures from db2 luw federation.
On non-federated db2 calling the overloaded procedure does not
cause an error, but on federated db2 calling the overloaded
procedure causes an errror. They are using the zos syntax.
CREATE OR REPLACE PROCEDURE NK_SP91MM1 SOURCE SYSADM.SP91MM1
UNIQUE ID 'version V1' FoR SERVER SERVER1 WITH RETURN TO CALLER
ALL
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "Duplicate parameter in the list".)
SQLSTATE=58004 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* NA *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 Version 11.5.7.0 *
**************************************************************** |
| Local Fix: |
NA |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* NA *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 Version 11.5.7.0 *
**************************************************************** |
| Comment |
Problem was first fixed in Db2 Version 11.5.7.0 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.11.2021
17.12.2021
17.12.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
