IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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:

    IT41644

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