DB2 FOR LUW / DB2FORLUW / B10 - DB2

Db2 traps with signal #11 when INSERT with a recursive SELECT is
run on a federated server such as this example:

INSERT INTO H_EMP
SELECT NAME,
      LEVEL,
      SALARY,
      CONNECT_BY_ROOT NAME AS ROOT,
      'Smith',
      SUBSTR(SYS_CONNECT_BY_PATH(NAME, ':'), 1, 25) AS CHAIN
FROM MY_EMP
START WITH NAME = 'Smith'
CONNECT BY NOCYCLE PRIOR EMPID = MGRID
ORDER SIBLINGS BY SALARY;

(H_EMP is the nickname of the table in the federated server)

The stack will show many calls of sqlnd_qtb_enforce_dam:

addElem
sqlnd_equal_or_lower
sqlnd_qtb_enforce_dam
...
sqlnd_qtb_enforce_dam
sqlnd_qtb_iud_postpass_pda
sqlnd_qtb_postpass_pda
sqlnd_qtb_pda
sqlnd_qtb_pda
sqlnd_qtb_pda
sqlnd_main
sqlnr_optprep_chunk3
sqlnr_optprep_chunk3_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_exe

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

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

21.02.2019
16.01.2020
16.01.2020