IT26282: UPDATE ON FULL TABLE WHICH USES SUB_SELECT COULD INCORRECTLY SET VALUES TO NULL FOR COLUMN BEING UPDATED.

Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Update using a sub-select on the full table could incorrectly
  set column value to NULL.
  Single row update is correct and is setting a proper value for
  the column.
  
  The problem only exists in  v11.
  
  example:
  
  update test1 t1 set col_a =  (select t2.col_a  from test2 t2
  where t1.col_a = t2.col_a)
  
  col_a  will be updated to NULL incorrectly.
  

Local fix

• db2set DB2COMPOPT=NO_UPDATE_COMP
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Please, see Error Description and install this Fix: v11      *
  * Fixpak 4.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please, see Error Description and install this Fix: v11      *
  * Fixpak 4.                                                    *
  ****************************************************************
  

Problem conclusion

• Please, see Error Description and install this Fix: v11 Fixpak
  4.
  

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

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels