JR63050: PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION)

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

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 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