Fixes are available
APAR status
Closed as program error.
Error description
Updates thru query with placeholder shows strange characters. db2 "update XXXX.test_utf8 set (vcol2) = (select * from (values ('YYYY'))) where vcol2 = 'vcol2'" [db2inst0@db2-cdc trace]$ db2 "select * from XXXX.test_utf8" ICOL1 VCOL2 -------------------- ---------------------------------------------------------------- -------------------------- 1 ???
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Runing UPDATE on MariaDB got unexpected characters * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.4.7 * ****************************************************************
Problem conclusion
The update statement got expected result on Db2 v11.4.7
Temporary fix
Comments
APAR Information
APAR number
JR63050
Reported component name
FEDERATION SERV
Reported component ID
5724N9700
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-11-19
Closed date
2021-11-11
Last modified date
2021-11-11
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
FEDERATION SERV
Fixed component ID
5724N9700
Applicable component levels
RB10 PSN
UP
RB10 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022