IBM Support

IT35418: SELECT DISTINCT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A SELECT DISTINCT SQL statement leads to sql0901N "invalid qnc
    assigment"
    
    related db2diag.log entries:
    
    2020-12-08-14.58.22.082024+060 E697314A2655         LEVEL: Info
    (Origin)
    PID     : 19333626             TID : 107623         PROC :
    db2sysc 0
    INSTANCE: db2xxx             NODE : 000           DB   :
    xxx
    APPHDL  : 0-34379              APPID:
    xxx.xxx.xxxx
    AUTHID  : xxx                HOSTNAME: xxx
    EDUID   : 107623               EDUNAME: db2agent (xxx) 0
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
    MESSAGE : ZRC=0x80310025=-2144272347=SQLNN_E_BAD
              "unexpected error and state is bad"
    DATA #1 : String, 62 bytes
    An unexpected error was detected during statement compilation.
    DATA #2 : Boolean, 1 bytes
    true
    DATA #3 : Boolean, 1 bytes
    false
    DATA #4 : Boolean, 1 bytes
    true
    DATA #5 : Boolean, 1 bytes
    false
    DATA #6 : Hex integer, 4 bytes
    0x00000000
    DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 21
     sqlerrmc: invalid qnc assigment
     sqlerrp : SQLNQ085
     sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFF9C      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
    
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    DATA #8 : Hex integer, 4 bytes
    0x00000040
    DATA #9 : String with size, 1000 bytes
    select distinct ....
    DATA #10: String, 294 bytes
    Compiler error stack for rc = -2144272347:
    sqlnn_cmpl[370]
    sqlnr_exe[200]
    sqlnr_rcc[100]
    sqlnr_seq[100]
    sqlnr_comp[110]
    sqlnr_prep1_action[100]
    sqlnr_qrwprep_phase1[395]
    sqlnr_process_hxp_scalag[150]
    sqlnr_splitswbox[60]
    box_opr_split[280]
    sqlnq_pid::qun_update[21]
    sqlnq_pid::replace_qnc[100]
    
    FODC_AppErr stack trace:
    
    sqlnn_erds__FiN41e + 0x110
    sqlnq_pid::replace_qnc(sqlnq_qnc *, sqlnq_typeCheck) + 0x6D0
    sqlnq_pid::qun_update(sqlnq_qun **, sqlnq_qun **, int,
    sqlnq_colmap *, sqlnq_typeCheck, int) + 0x39C
    sqlnq_qtb::box_opr_split(sqlnq_pid *, sqlnq_qun **, int, int,
    sqlnq_stk *&, sqlnq_qun **, int (*)(sqlnq_prd *, int, unsigned
    char *), unsigned char *, int, int, int, int, bool, bool) +
    0xBC4
    sqlns_presplit_box_for_expand_sql_fncs(sqlnq_opr *, loc *) +
    0x6CC
    sqlns_expand_sql_fncs_in_qur(sqlnq_qur *, loc *) + 0x56C
    sqlns_qgs(sqlnq_qur *, sqlnq_requestType, char *) + 0x16A8
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sqlnq_qur + 0x7D44
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35418

  • 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

    2021-01-06

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022