IBM Support

IT22941: TRAP/901 WHEN XML COLUMN NOT REFERENCED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Db2 may abend or generate 901 when the following conditions are
    met:
    1) The query has one or more subqueries
    2) There is an xmlcolumn in one of the subquerries
    3) There is no reference of the xmlcolumn in the main query.
    
    Example:
    CREATE TABLE TABKVER (
        BKVER_VGN         SMALLINT    NOT NULL,
        BKVER_GUEL_AB_DT        CHARACTER(20 OCTETS)    NOT NULL);
    
    WITH KFZ_VERTRAG AS (
           SELECT x1. *, XMLCAST(XMLQUERY('string($D) castable as
    xs:date' PASSING x1.BKVER_GUEL_AB_DT AS D) AS VARCHAR(100)) AS
    BKVER_GUEL_AB_DT_AS_DATE FROM TABKVER x1 ),
         STICHTAGE( STICHTAG) AS
           (SELECT DATE('2014-01-01') AS STICHTAG    FROM
    SYSIBM.SYSDUMMY1),
         KFZ_VERTRAG_MAX_SEGMENT AS
           (SELECT D.STICHTAG,MAX(V.BKVER_VGN) AS MAX_VGN FROM
    KFZ_VERTRAG V,STICHTAGE D GROUP BY D.STICHTAG),
         KFZ_VERTRAG_FILTER_MAX_SEGMENTE AS
           (SELECT MS.STICHTAG FROM KFZ_VERTRAG KVV,
    KFZ_VERTRAG_MAX_SEGMENT MS)
    SELECT * FROM KFZ_VERTRAG_FILTER_MAX_SEGMENTE KMV;
    
    the stack looks like:
    box_copy__9sqlnq_qtbFPP9sqlnq_qtbP9sqlnq_quriN43bT8
    sqlns_deep_box_copy__FP9sqlnq_qtbP9sqlnq_qunRP9sqlnq_qtbCiT4PFP9
    sqlnq_qunPUcRiRPP9sqlnq_qunT4PP9sqlnq_qunT6RP12sqlnq_colmapT3_iP
    UcbiN28
    sqlns_graph_copy__FP9sqlnq_qunCiN22PCiiT2PFP9sqlnq_quniPUcRi_iPU
    cPFP9sqlnq_qunPUcRiRPP9sqlnq_qunT4PP9sqlnq_qunT6RP12sqlnq_colmap
    T3_iT9bT12_T6N212_ + 0x8D0
    sqlnq_copy_box_and_correlation__FP9sqlnq_qtbP9sqlnq_qunCiiRP9sql
    nq_qtbN24bT8 + 0x470
    sqlnr_break_cse_box__FP9sqlnq_qtbPii + 0xBDC
    sqlnr_selucom_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x1A0
    sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
    s + 0x474
    sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
    0x1D8
    sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1B4
    sqlnr_perqun_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x164
    sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
    s + 0x474
    sqlnr_priority__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass
    + 0x158
    sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1FC
    sqlnr_allqun_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x1F8
    sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
    s + 0x474
    sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
    0x1D8
    sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1B4
    sqlnr_start_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x55C
    sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres
    s + 0x474
    sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
    0x1D8
    sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x1B4
    sqlnr_exe__FP9sqlnq_qur + 0xBF0
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sqlnq_qur + 0x63AC
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_env + 0x64
    sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
    LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0x1F30
    sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
    T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
    SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x101C
    sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x2920
    sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x42C
    sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x20C
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x288
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x290
    sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x6CC
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x1D0
    sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x59C
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x2EC
    RunEDU__8sqeAgentFv + 0x46C
    EDUDriver__9sqzEDUObjFv + 0x23C
    sqlzRunEDU__FPcUi + 0x3C
    sqloEDUEntry + 0x7B4
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 11.1.1.1                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.4 or next release                          *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT22941

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-26

  • Closed date

    2022-04-12

  • Last modified date

    2022-04-12

  • APAR is sysrouted FROM one or more of the following:

    IT22884

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RB10 PSN

       UP

  • RB10 PSY

       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