IBM Support

IT19440: SQL0901N WHEN COLUMN MASK ON NOT NULLABLE COLUMN RETURNS ALWAYS NOT NULL AND COLUMN IS IN NULL PRODUCING SIDE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 LUW v11.1 Mod 3 Fixpack 3                     *
    ****************************************************************
    

Problem conclusion

  • First Fixed in Db2 LUW v11.1 Mod 3 Fixpack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT19440

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-27

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

  • APAR is sysrouted FROM one or more of the following:

    IT19438

  • 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

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 March 2018