JR63109: SQL1822 ON FEDERATION SERVER BETWEEN UTF8 AND ISO-1 DATABASE WHEN THE SERVER OPTION IS STRING_UNITS 'S'

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT41644

Fix information

• Fixed component name

  FEDERATION SERV

• Fixed component ID

  5724N9700

Applicable component levels