IBM Support

IC70161: DB2 MAY ABEND WHILE TRYING TO COMPILE A QUERY WITH 1 = 0 PREDICATE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • DB2 might abend while compiling a query containing a 1 = 0
    predicate. The query might
    also be referencing a union all view with 12 or more branches.
    
    The stack trace looks similar to:
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x0900000001DB16BC validateOnGetBlock__7SMdPoolCFv + 0x0
    0x0900000000C60474 sqlofmblkEx + 0xEC
    0x0900000001F8DD48 sqlng_pop__FP9sqlng_blkPPUcP13SQLNG_ELEMENT +
    0x20
    0x0900000001B1E808
    sqlng_build_PSR__FP9sqlng_blkUliPcP9sqlnq_funP17sqlnn_dat_TYPTYP
    EN23P10sqlri_ufobP9sqlnq_pid + 0x218
    0x0900000001B1BF5C
    sqlng_build_UFOB_obj__FP9sqlng_blkP9sqlnq_pidPP10sqlri_ufob +
    0x14A0
    0x0900000001B1A818
    sqlng_build_U_X_op__FP9sqlng_blkPP12sqlri_opparmP9sqlnq_pid +
    0x78
    0x09000000036F3F54
    sqlng_process_parse_tree_node__FP9sqlng_blkP9sqlnq_pid + 0x580
    0x0900000003B35514
    sqlng_process_BF_node__FP9sqlng_blkP9sqlnq_pid + 0x134
    0x0900000003B34234 sqlng_walk_HXP_chain__FP9sqlng_blk + 0x318
    0x0900000003B3151C
    sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x72C
    0x0900000003B57EB8
    sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb +
    0x1FC0
    0x0900000003B73C94
    sqlng_process_scan_op__FP9sqlng_blkP19sqlno_plan_operator +
    0xB94
    0x0900000003B30F48
    sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158
    0x0900000003B685B8
    sqlng_process_nljn_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x14B4
    0x0900000003725064
    sqlng_process_unique_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x404
    0x0900000003B7B1B4
    sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x490
    0x0900000003B825C0
    sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x36C
    0x090000000372A724
    sqlng_process_groupby_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x3A8
    0x0900000003B7B1B4
    sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x490
    0x0900000003B825C0
    sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x36C
    0x0900000003B7B1B4
    sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x490
    0x0900000003B825C0
    sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x36C
    0x0900000003B83068
    sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator +
    0x868
    0x0900000003B30F48
    sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158
    0x09000000036E47B8 sqlng_main__FP9sqlnq_qur + 0x2D40
    0x090000000370CAD4 sqlng_main__FP9sqlnq_qur@glue1229 + 0x70
    0x0900000001F2EAF8
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sqlnq_qur + 0x1DB8
    0x0900000000FA5210
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_env + 0x24
    ***********0x0900000000FA723C
    sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P16sqlra
    _cached_varPiPUl + 0x60C
    0x0900000000FF9F6C
    sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
    T4PUcT4UsUcP14sqlra_cmpl_enviPiT11_T12_N311_T12_P14SQLP_LOCK_INF
    OPP16sqlra_cached_varT12_PUlb + 0x400
    0x0900000000FFD128 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x440
    0x09000000028EFA6C
    sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x138
    0x09000000021A244C
    sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0xAE4
    0x090000000115F038
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x14C
    0x0900000000EDD760
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
    0x0900000000EDF260 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
    + 0x218
    0x0900000000FD4804
    @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
    0x0900000000FD465C
    @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
    0x0900000000FD43E4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0xD8
    0x0900000000DA0BC4 RunEDU__8sqeAgentFv + 0x11C
    0x0900000000DA0940 EDUDriver__9sqzEDUObjFv + 0x94
    0x0900000000D9A8B8 sqloEDUEntry + 0x57C
    </StackTrace>
    
    Classification: Defect info: wsdbu00775699
    
    Fix In Product: DB2 v9.5 fixpak 7
    

Local fix

  • As a work around customers can use opt level 3
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 MAY ABEND WHILE TRYING TO COMPILE A QUERY WITH 1 = 0     *
    * PREDICATE.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 might abend while compiling a query containing a 1 = 0   *
    *                                                              *
    * predicate. The query might                                   *
    *                                                              *
    * also be referencing a union all view with 12 or more         *
    * branches.                                                    *
    *                                                              *
    *                                                              *
    * The stack trace looks similar to:                            *
    *                                                              *
    * <StackTrace>                                                 *
    *                                                              *
    * -------Frame------ ------Function + Offset------             *
    *                                                              *
    * 0x0900000001DB16BC validateOnGetBlock__7SMdPoolCFv + 0x0     *
    *                                                              *
    * 0x0900000000C60474 sqlofmblkEx + 0xEC                        *
    *                                                              *
    * 0x0900000001F8DD48                                           *
    * sqlng_pop__FP9sqlng_blkPPUcP13SQLNG_ELEMENT +                *
    * 0x20                                                         *
    *                                                              *
    * 0x0900000001B1E808                                           *
    *                                                              *
    * sqlng_build_PSR__FP9sqlng_blkUliPcP9sqlnq_funP17sqlnn_dat_TYPT
    * EN23P10sqlri_ufobP9sqlnq_pid + 0x218                         *
    *                                                              *
    * 0x0900000001B1BF5C                                           *
    *                                                              *
    * sqlng_build_UFOB_obj__FP9sqlng_blkP9sqlnq_pidPP10sqlri_ufob  *
    * +                                                            *
    * 0x14A0                                                       *
    *                                                              *
    * 0x0900000001B1A818                                           *
    *                                                              *
    * sqlng_build_U_X_op__FP9sqlng_blkPP12sqlri_opparmP9sqlnq_pid  *
    * +                                                            *
    * 0x78                                                         *
    *                                                              *
    * 0x09000000036F3F54                                           *
    *                                                              *
    * sqlng_process_parse_tree_node__FP9sqlng_blkP9sqlnq_pid +     *
    * 0x580                                                        *
    * 0x0900000003B35514                                           *
    *                                                              *
    * sqlng_process_BF_node__FP9sqlng_blkP9sqlnq_pid + 0x134       *
    *                                                              *
    * 0x0900000003B34234 sqlng_walk_HXP_chain__FP9sqlng_blk +      *
    * 0x318                                                        *
    * 0x0900000003B3151C                                           *
    *                                                              *
    * sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x72C    *
    *                                                              *
    * 0x0900000003B57EB8                                           *
    *                                                              *
    * sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb  *
    * +                                                            *
    * 0x1FC0                                                       *
    *                                                              *
    * 0x0900000003B73C94                                           *
    *                                                              *
    * sqlng_process_scan_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0xB94                                                        *
    *                                                              *
    * 0x0900000003B30F48                                           *
    *                                                              *
    * sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158    *
    *                                                              *
    * 0x0900000003B685B8                                           *
    *                                                              *
    * sqlng_process_nljn_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0x14B4                                                       *
    *                                                              *
    * 0x0900000003725064                                           *
    *                                                              *
    * sqlng_process_unique_op__FP9sqlng_blkP19sqlno_plan_operator  *
    * +                                                            *
    * 0x404                                                        *
    *                                                              *
    * 0x0900000003B7B1B4                                           *
    *                                                              *
    * sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0x490                                                        *
    *                                                              *
    * 0x0900000003B825C0                                           *
    *                                                              *
    * sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0x36C                                                        *
    *                                                              *
    * 0x090000000372A724                                           *
    *                                                              *
    * sqlng_process_groupby_op__FP9sqlng_blkP19sqlno_plan_operator *
    * +                                                            *
    * 0x3A8                                                        *
    *                                                              *
    * 0x0900000003B7B1B4                                           *
    *                                                              *
    * sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0x490                                                        *
    *                                                              *
    * 0x0900000003B825C0                                           *
    *                                                              *
    * sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0x36C                                                        *
    *                                                              *
    * 0x0900000003B7B1B4                                           *
    *                                                              *
    * sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0x490                                                        *
    *                                                              *
    * 0x0900000003B825C0                                           *
    *                                                              *
    * sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +  *
    *                                                              *
    * 0x36C                                                        *
    *                                                              *
    * 0x0900000003B83068                                           *
    *                                                              *
    * sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator  *
    * +                                                            *
    * 0x868                                                        *
    *                                                              *
    * 0x0900000003B30F48                                           *
    *                                                              *
    * sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158    *
    *                                                              *
    * 0x09000000036E47B8 sqlng_main__FP9sqlnq_qur + 0x2D40         *
    *                                                              *
    * 0x090000000370CAD4 sqlng_main__FP9sqlnq_qur@glue1229 + 0x70  *
    *                                                              *
    * 0x0900000001F2EAF8                                           *
    *                                                              *
    * sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14
    * lrr_cmpl_enviT7PP9sqlnq_qur + 0x1DB8                         *
    *                                                              *
    * 0x0900000000FA5210                                           *
    *                                                              *
    * sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14
    * lrr_cmpl_env + 0x24                                          *
    *                                                              *
    * ***********0x0900000000FA723C                                *
    *                                                              *
    * sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P16sql
    * _cached_varPiPUl + 0x60C                                     *
    *                                                              *
    * 0x0900000000FF9F6C                                           *
    *                                                              *
    * sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_id
    * T4PUcT4UsUcP14sqlra_cmpl_enviPiT11_T12_N311_T12_P14SQLP_LOCK_I
    * OPP16sqlra_cached_varT12_PUlb + 0x400                        *
    *                                                              *
    * 0x0900000000FFD128 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 +      *
    * 0x440                                                        *
    * 0x09000000028EFA6C                                           *
    *                                                              *
    * sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x138 *
    *                                                              *
    * 0x09000000021A244C                                           *
    *                                                              *
    * sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject +    *
    * 0xAE4                                                        *
    * 0x090000000115F038                                           *
    *                                                              *
    * sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
    * interface + 0x14C                                            *
    *                                                              *
    * 0x0900000000EDD760                                           *
    *                                                              *
    * sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124       *
    *                                                              *
    * 0x0900000000EDF260                                           *
    * @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb                *
    * + 0x218                                                      *
    *                                                              *
    * 0x0900000000FD4804                                           *
    *                                                              *
    * @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98  *
    *                                                              *
    * 0x0900000000FD465C                                           *
    *                                                              *
    * @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0   *
    *                                                              *
    * 0x0900000000FD43E4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
    * +                                                            *
    * 0xD8                                                         *
    *                                                              *
    * 0x0900000000DA0BC4 RunEDU__8sqeAgentFv + 0x11C               *
    *                                                              *
    * 0x0900000000DA0940 EDUDriver__9sqzEDUObjFv + 0x94            *
    *                                                              *
    * 0x0900000000D9A8B8 sqloEDUEntry + 0x57C                      *
    *                                                              *
    * </StackTrace>                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * As a work around customers can use opt level 3               *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC70161

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-26

  • Closed date

    2011-05-12

  • Last modified date

    2011-05-12

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

    IZ80977

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

Fix information

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 May 2011