DB2 FOR LUW / DB2FORLUW / B10 - DB2

When running a query the instance may crash in
sqlrh_free_handle.

The db2diag.log will show the following error:
2018-02-27-12.46.19.618372+060 I291624A1578         LEVEL: Error
PID     : 2490950              TID : 3600           PROC :
db2sysc 3
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-66                 APPID: 9.1.1.1.52400.180227114612
AUTHID  : DB2INST1             HOSTNAME: host
EDUID   : 3600                 EDUNAME: db2agntp (SAMPLE) 3
FUNCTION: DB2 UDB, runtime interpreter,
sqlrhFreeInternalHandles, probe:2950
MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
          "SQLCA has already been built"
CALLED  : DB2 UDB, runtime interpreter, sqlrh_free_handle
RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
          "SQLCA has already been built"
DATA #1 : String, 42 bytes
sqlrhFreeInternalHandles: Unexpected error
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -423   sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRI0A7
sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0xFFFFFFF6      (6)
0x00000003
sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
sqlstate:
DATA #3 : Pointer, 8 bytes
0x0a0001000006b780
DATA #4 : unsigned integer, 4 bytes
18560
DATA #5 : Dumped object of size 74248 bytes at offset 0, 58
bytes
/home/db2inst1/sqllib/db2dump/2490950.3600.000.dump.bin
DATA #6 : Pointer, 8 bytes
0x0a0001000006c788
DATA #7 : Hex integer, 4 bytes
0xFAB0A000
DATA #8 : Pointer, 8 bytes
0x0a0001000007d984
DATA #9 : Hex integer, 4 bytes
0x00000000

The stack for the crash will similar to the following:

sqlrh_free_handle(sqlrr_cb*,unsigned int*,int,unsigned
char*,unsigned int,unsigned long,bool) + 0x208
sqlrhFreeInternalHandles(sqlrr_cb*,sqlrh_InternalHandleList**) +
0x1A8
sqlricls_complex(sqlrr_cb*,int,long,long,long) + 0x2AE4
Nested signal handlers detected


This crash is dependent on the data that is being processed as
part of the query.

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

See LOCAL FIX.

forerunner  : IT24539 
follow-up : 

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

05.04.2018
27.11.2018
27.11.2018