IBM Support

IT28192: DB2 TRAPS WHEN AN INSERT WITH A RECURSIVE SELECT IS RUN ON A FEDERATED SERVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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
    

Local fix

Problem summary

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

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28192

  • 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

    2019-02-21

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

       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:
03 May 2022