A fix is available
APAR status
Closed as program error.
Error description
SQL1822N error is returned when the communication between the UT8 database and the ISO-1 databases while the server option STRING_UNITS is 'S'. The remote server is ISO-1 codepage with STRING_UNITS = 'SYSTEM', the local DB2 is in UTF-8 database with 'CODEUNITS32'. SQL1822N returned if the server option STRING_UNITS is setted to 'S' in the federation server. Db2 database: Default string units (STRING_UNITS) = CODEUNITS32 Database code page = 1208 Database code set = UTF-8 Remote database: Default string units (STRING_UNITS) = SYSTEM Database code page = 819 Database code set = ISO8859-1 SELECT * FROM <nickname> WHERE <chr_col> IN ('ABC','DEF','GHI') 1 ---------- SQL1822N Unexpected error code "560AA" received from data source "ISO". Associated text and tokens are "func="do_prep" msg=" SQL1233N The statement failed because ". SQLSTATE=560BD
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * SQL1822 ON FEDERATION SERVER * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to product to Db2 V11.4.7 * ****************************************************************
Problem conclusion
SQL1822N error when STRING_UNITS is 'S' problem is fixed in Db2 V11.4.7.
Temporary fix
Comments
APAR Information
APAR number
JR63109
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-12-07
Closed date
2022-03-01
Last modified date
2022-03-01
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
[{"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:
29 July 2022