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

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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