IBM Support

JR62802: PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION)

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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:                                              *
    * Updates thru query with placeholder shows strange            *
    * characters.                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to	db2_v111m4fp6                                     *
    ****************************************************************
    

Problem conclusion

  • upgrade to	db2_v111m4fp6
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR62802

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-09-15

  • Closed date

    2021-06-18

  • Last modified date

    2021-06-18

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5"}]

Document Information

Modified date:
19 June 2021