DB2 FOR LUW / DB2FORLUW / A50 - DB2

Example:

create table tgen (i int, j int, k int not null generated always
as (i+j)) organize by row

If values for columns i or j  are NULL , then generated value
for column k is NULL.
This row therefore is invalid as k is a not null column.
However it is possible to end up loading this row into the
table.

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 10.5 Fix Pack 11 or higher                    *
****************************************************************

Define both columns i and j as "not null", or otherwise ensure
that the load source does not have NULL values for either of
these columns

not known / see Local fix

forerunner  : 
follow-up : IT27748 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.01.2019
25.02.2020
25.02.2020