APAR status
Closed as program error.
Error description
On z/OS, a message flow that calls a DB2 stored procedure with a parameter of data type BIGINT might fail with the following error when MQSI_DB2_CONVERSION=UNICODE is set: BIP2322E DATABASE ERROR: SQL STATE '22003'; NATIVE ERROR CODE '-99999'; ERROR TEXT '{DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=22003 ERRLOC=2:70:2'
Local fix
NA
Problem summary
**************************************************************** USERS AFFECTED: All users of IBM Integration Bus on z/OS using BIGINT parameters in DB2 stored procedures when DB2 conversion is set to UNICODE. Platforms affected: z/OS **************************************************************** PROBLEM DESCRIPTION: On z/OS, a message flow that calls a DB2 stored procedure with a parameter of data type BIGINT might fail with the following error when MQSI_DB2_CONVERSION=UNICODE is set: BIP2322E DATABASE ERROR: SQL STATE '22003'; NATIVE ERROR CODE '-99999'; ERROR TEXT '{DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=22003 ERRLOC=2:70:2' There are a number of resource name changes between WebSphere Message Broker and IBM Integration Bus Version 9.0. For details visit http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.e tools.mft.doc/bb23814_.htm
Problem conclusion
The product on z/OS now binds BIGINT parameters using the correct C data type when DB2 conversion is UNICODE. --------------------------------------------------------------- The fix is targeted for delivery in the following PTFs: Version Maintenance Level v9.0 9.0.0.6 v10.0 10.0.0.5 The latest available maintenance can be obtained from: http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041 If the maintenance level is not yet available,information on its planned availability can be found on: http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308 ---------------------------------------------------------------
Temporary fix
Comments
APAR Information
APAR number
PI58727
Reported component name
IB Z/OS
Reported component ID
5655IBB00
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-03-08
Closed date
2016-05-25
Last modified date
2016-05-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IB Z/OS
Fixed component ID
5655IBB00
Applicable component levels
R900 PSY
UP
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"9.0","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
14 December 2020