DB2 FOR LUW / DB2FORLUW / B10 - DB2

DB2 may produce 901 with unexpected avgBuildTupleSize=0 when
following conditions are satisfied:
1. The query has one or more complex joins.
2. There are join columns of type
char/varchar/graphic/vargraphic with length < 4.

2017-04-13-13.21.40.392077+540 E724316423A2800      LEVEL: Info
(Origin)
PID     : 12345                TID : 70349177680304 PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-51707              APPID:
*LOCAL.db2inst1.170413041909
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 37277                EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
          "unexpected error but state is OK"
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: 30
sqlerrmc: unexpected avgBuildTupleSize=0
sqlerrp : SQLNG060
sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000744      (5) 0xFFFFF866      (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 * FROM ..(snip)...
DATA #10: String, 435 bytes
Compiler error stack for rc = -2144272209:
sqlnn_cmpl[415]
sqlng_main[3024]
sqlng_main[1707]
sqlng_build_thread[890]
sqlngProcessLolepop[550]
sqlng_process_return_op[1652]
sqlngProcessLolepop[550]
sqlng_process_pipe_op[889]
sqlngProcessLolepop[550]
sqlng_process_mate_op[1504]
sqlngProcessLolepop[550]
sqlng_process_pipe_op[889]
sqlngProcessLolepop[550]
sqlng_process_mate_op[1504]
sqlngProcessLolepop[550]
sqlng_process_hsjn_op[1946]

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
****************************************************************

not known / see Local fix

forerunner  : IT20559 
follow-up : 

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

14.05.2017
28.01.2020
28.01.2020