DB2 FOR LUW / DB2FORLUW / A50 - DB2

Under rare scenarios DB2 might produce SQL0901N if the 
following conditions are true: 
1) One or more tables in the query have Row and Column Access 
Control (RCAC) declared on them 
2) One or more of the columns on which a RCAC mask is declared 
are marked as not nullable 
3) The table(s) are referenced in the null-producing side of a 
left outer join 
 
Example: 
create Table T2(key varchar(8) not null, c1 int); 
CREATE MASK MASK_KEY ON T2 FOR COLUMN "KEY" RETURN case when 
VERIFY_ROLE_FOR_USER(SESSION_USER,'CONFIDENTIAL')=1  THEN KEY 
else 'xxxxxxxx' END  ENABLE; 
 
select * from T1 left join T2 on t1.c1 = t2.c1; 
 
SQL0901N  The SQL statement or command failed because of a 
database system 
error. (Reason "unexpected type".)  SQLSTATE=58004 
 
<Stack> 
sqlns_qgs 
sqlnq_compile_fgac 
sqlnq_apply_column_level_access_control 
sqlnq_apply_column_read_level_access_control 
sqlnq_identify_mask_location 
sqlnq_fun_tres 
sqlnq_fun_res_walk 
sqlnq_encap_doit 
sqlnq_encap_cast_rtn 
sqlnq_encap_cast_check_char_len 
</Stack>

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 v10.5.0.5                              * 
****************************************************************

Problem is fixed in DB2 version 10.5 fix pack 5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.05.2014
18.03.2015
28.02.2017