DB2 FOR LUW / DB2FORLUW / A10 - DB2

An SQL0901N error may be returned when a column mask is defined 
on a column which is nullable, and the column mask CASE 
expression always returns a non-null result.  For example, 
assume null values can be assigned to column c1.  The following 
mask is guaranteed to return a non-null result (the integer 
constant 0 or 1): 
 
create mask m1 on t1 for column c1 return case when c1 is not 
null then 1 else 0 end enable 
 
A query which contains the masked column in the final result 
table can fail with SQL0901N.  The only known occurrence is in 
DPF 
environments, and is demonstrated in the scenario below. 
 
create table t1 (c1 varchar(10)) 
DB20000I  The SQL command completed successfully. 
 
insert into t1 values null, 0, 1, 2 
DB20000I  The SQL command completed successfully. 
 
create mask m1 on t1 for column c1 return case when c1 is not 
null then 1 else 0 end enable 
DB20000I  The SQL command completed successfully. 
 
alter table t1 activate column access control 
DB20000I  The SQL command completed successfully. 
 
select c1 from t1 
 
C1 
---------- 
SQL0901N  The SQL statement or command failed because of a 
database system error. (Reason "probe 030 in sqlkt_pack_tuple(), 
msg=cold=NULLABLE zvalue=NONULLS col(".)  SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 for LUW users in a DPF environment                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.1 Fix Pack 5                           * 
****************************************************************

First fixed in Version 10.1 Fix Pack 5

not known / see Local fix

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

27.03.2015
15.07.2015
15.07.2015