DB2 FOR LUW / DB2FORLUW / A50 - DB2

DB2 may generate SQL0901N when the following conditions are met: 
1. The query has multiple joins and at least one Outer Join. 
2. Null producing side table of Outer Join has always not null 
column mask 
3. Column having column mask is not nullable. 
4. DPF Database. 
 
Error generated: 
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 
 
db2diag.log: 
 
2017-02-21-07.12.53.889909-360 I3528A634            LEVEL: Error 
PID     : 9306480              TID : 128111         PROC : 
db2sysc 5 
INSTANCE: db2inst1             NODE : 005           DB   : 
SAMPLE 
APPHDL  : 0-390                APPID: *N0.db2inst1.170221131007 
AUTHID  : db2inst1             HOSTNAME: db2hostname 
EDUID   : 128111               EDUNAME: db2agntp (SAMPLE) 5 
FUNCTION: DB2 UDB, table Q services, sqlkt_pack_tuple, probe:30 
MESSAGE : DIA0001E An internal error occurred. Report the 
following error code 
          : "Line=02444, rc1=0x82170001, rc2=0x00000000, rc3=0, 
          msg=cold=NULLABLE zvalue=NONULLS col(1)". 
 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000000100158 thread_wait + 0x98 
0x0900000079178A38 sqloWaitEDUWaitPost + 0x45C 
0x0900000079177AD8 WaitRecvReady__11sqkfChannelFiT1 + 0x298 
0x0900000077620CFC 
ReceiveAnyBuffer__11sqkfChannelFPP10sqkfBufferiPi + 0x620 
0x0900000074BA5CD0 sqlktrcv__FP9sqlri_taoPi + 0x470 
0x0900000074BBBA48 
sqlkt_unpack_tuple__FP9sqlri_taoPiPbP5sqlcaPUiPUlP8sqeAgent + 
0x68C 
0x0900000074BBBA48 
sqlkt_unpack_tuple__FP9sqlri_taoPiPbP5sqlcaPUiPUlP8sqeAgent + 
0x68C 
0x0900000074BBADB4 sqlritqa__FP8sqlrr_cb + 0x12C0 
0x090000007A1A826C pdLogPrintf + 0x28 
0x0900000079545CFC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 
0x90 
0x0900000079175F00 
sqlrr_process_fetch_request__FP14db2UCinterface + 0x1A8 
0x0900000079174020 
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0xA10 
0x09000000798132B8 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0xD04 
0x090000007980A7E0 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x11E4 
0x090000007980A7E0 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x11E4 
0x090000007980A3D4 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0xDD8 
0x090000007A5783E4 
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8 
0x090000007A578EF8 
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5FC 
0x0900000079FC885C RunEDU__8sqeAgentFv + 0x40E1C 
0x0900000079F3D638 RunEDU__8sqeAgentFv + 0x124 
0x0900000078D529E4 EDUDriver__9sqzEDUObjFv + 0x130 
0x09000000789E41D4 sqloEDUEntry + 0x3A0 
</StackTrace>

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

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

27.02.2017
29.09.2017
29.09.2017

9.0.