IBM Support

IC73541: DB MAY ABEND WHILE EXECUTING AN OLAP QUERY WITH A BOUNDED WINDOW AGGREGATION RANGE GROUPING.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The database may abend when an OLAP query is executed:
    The query must have the following:
    1. Be a Range window grouping
    2. The range must be bounded
    3. There must be an order by clause as part of scalar
    aggregation
    
    The stack trace observed is as follows:
    <stacktrace>
    
    <?getVars@psm_ASSOCIATE_STMT_node@@QAEPAVpsm_IOvars@@XZ>
    <T:/db2_v95fp7/nt32/s101129/engn/include/sqluueff.h:1048>
    <__VInfreq_?sqlng_build_SCALAG_op@@YAHPAUsqlng_blk@@PAUsqlno_pla
    n_operator@@@Z>
    <sqlng_opr.C:-1>
    <?sqlng_process_mate_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operator
    @@@Z>
    <sqlng_opt.C:1745>
    <?sqlng_process_pipe_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operator
    @@@Z>
    <sqlng_opt.C:1342>
    <?sqlng_process_mate_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operator
    @@@Z>
    <sqlng_opt.C:1732>
    <?sqlng_process_pipe_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operator
    @@@Z>
    <sqlng_opt.C:1342>
    <?sqlng_process_return_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operat
    or@@@Z>
    <sqlng_opt.C:1047>
    <?sqlng_build_thread.@@YAHPAUsqlng_blk@@PAUsqlng_thd_ctrl@@@Z>
    <sqlng_aux.C:640>
    <?sqlng_main@@YAHPAVsqlnq_qur@@@Z> <sqlng_exe.C:1653>
    <?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compileMo
    de@@FPAUsqlrr_cmpl_env@@HHPAPAVsqlnq_qur@@@Z>
    <sqlnn_cmpl.C:3705>
    <?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compileMo
    de@@FPAUsqlrr_cmpl_env@@@Z>
    <sqlnn_cmpl.C:498>
    <?sqlra_compile_var@@YAHPAUsqlrr_cb@@PAUsqlra_cmpl_env@@PAEHGHHH
    HHPAUsqlra_cached_var@@PAHPA_K@Z>
    <sqlra_cmpl.C:955>
    <?sqlra_find_var@@YAHPAUsqlrr_cb@@PAUsqlra_cached_stmt@@Usqlra_s
    tmt_id@@IIPAEIGEPAUsqlra_cmpl_env@@HPAHH5HHH5PAUSQLP_LOCK_INFO@@
    PAPAUsqlra_cached_var@@5PA_K_N@Z>
    <sqlra_dyn.C:3509>
    <?sqlra_get_var@@YAHPAUsqlrr_cb@@HH_NPA_N2@Z> <sqlra_var.C:589>
    <?sqlrr_prepare@@YAHPAUdb2UCinterface@@PAUdb2UCprepareInfo@@@Z>
    <sqlrr_req_sql.C:2965>
    <?sqljs_ddm_prpsqlstt@@YAHPAUdb2UCinterface@@PAUsqljDDMObject@@@
    Z>
    <sqljspds.C:633>
    <?sqljsParseRdbAccessed.@@YAHPAUsqljsDrdaAsCb@@PAUsqljDDMObject@
    @PAUdb2UCinterface@@@Z>
    <sqljspar.C:414>
    <?sqljsParse@@YAHPAUsqljsDrdaAsCb@@PAUdb2UCinterface@@@Z>
    <sqljspar.C:881>
    ..
    ....
    </stacktrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * V97FP1                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The database may abend when an OLAP query is executed:       *
    *                                                              *
    * The query must have the following:                           *
    *                                                              *
    * 1. Be a Range window grouping                                *
    *                                                              *
    * 2. The range must be bounded                                 *
    *                                                              *
    * 3. There must be an order by clause as part of scalar        *
    *                                                              *
    * aggregation                                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    * The stack trace observed is as follows:                      *
    *                                                              *
    * <stacktrace>                                                 *
    *                                                              *
    *                                                              *
    *                                                              *
    * <?getVars@psm_ASSOCIATE_STMT_node@@QAEPAVpsm_IOvars@@XZ>     *
    *                                                              *
    * <T:/db2_v95fp7/nt32/s101129/engn/include/sqluueff.h:1048>    *
    *                                                              *
    * <__VInfreq_?sqlng_build_SCALAG_op@@YAHPAUsqlng_blk@@PAUsqlno *
    * _p                                                           *
    * n_operator@@@Z>                                              *
    *                                                              *
    * <sqlng_opr.C:-1>                                             *
    *                                                              *
    * <?sqlng_process_mate_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_oper *
    * at                                                           *
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1745>                                           *
    *                                                              *
    * <?sqlng_process_pipe_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_oper *
    * at                                                           *
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1342>                                           *
    *                                                              *
    * <?sqlng_process_mate_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_oper *
    * at                                                           *
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1732>                                           *
    *                                                              *
    * <?sqlng_process_pipe_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_oper *
    * at                                                           *
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1342>                                           *
    *                                                              *
    * <?sqlng_process_return_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_op *
    * er                                                           *
    * or@@@Z>                                                      *
    *                                                              *
    * <sqlng_opt.C:1047>                                           *
    *                                                              *
    * <?sqlng_build_thread.@@YAHPAUsqlng_blk@@PAUsqlng_thd_ctrl@@@ *
    * Z>                                                           *
    *                                                              *
    * <sqlng_aux.C:640>                                            *
    *                                                              *
    * <?sqlng_main@@YAHPAVsqlnq_qur@@@Z> <sqlng_exe.C:1653>        *
    *                                                              *
    * <?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compi *
    * le                                                           *
    * de@@FPAUsqlrr_cmpl_env@@HHPAPAVsqlnq_qur@@@Z>                *
    *                                                              *
    * <sqlnn_cmpl.C:3705>                                          *
    *                                                              *
    * <?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compi *
    * le                                                           *
    * de@@FPAUsqlrr_cmpl_env@@@Z>                                  *
    *                                                              *
    * <sqlnn_cmpl.C:498>                                           *
    *                                                              *
    * <?sqlra_compile_var@@YAHPAUsqlrr_cb@@PAUsqlra_cmpl_env@@PAEH *
    * GH                                                           *
    * HHPAUsqlra_cached_var@@PAHPA_K@Z>                            *
    *                                                              *
    * <sqlra_cmpl.C:955>                                           *
    *                                                              *
    * <?sqlra_find_var@@YAHPAUsqlrr_cb@@PAUsqlra_cached_stmt@@Usql *
    * ra                                                           *
    * tmt_id@@IIPAEIGEPAUsqlra_cmpl_env@@HPAHH5HHH5PAUSQLP_LOCK_IN *
    * FO                                                           *
    * PAPAUsqlra_cached_var@@5PA_K_N@Z>                            *
    *                                                              *
    * <sqlra_dyn.C:3509>                                           *
    *                                                              *
    * <?sqlra_get_var@@YAHPAUsqlrr_cb@@HH_NPA_N2@Z>                *
    * <sqlra_var.C:589>                                            *
    * <?sqlrr_prepare@@YAHPAUdb2UCinterface@@PAUdb2UCprepareInfo@@ *
    * @Z                                                           *
    * <sqlrr_req_sql.C:2965>                                       *
    *                                                              *
    * <?sqljs_ddm_prpsqlstt@@YAHPAUdb2UCinterface@@PAUsqljDDMObjec *
    * t@                                                           *
    * Z>                                                           *
    *                                                              *
    * <sqljspds.C:633>                                             *
    *                                                              *
    * <?sqljsParseRdbAccessed.@@YAHPAUsqljsDrdaAsCb@@PAUsqljDDMObj *
    * ec                                                           *
    * @PAUdb2UCinterface@@@Z>                                      *
    *                                                              *
    * <sqljspar.C:414>                                             *
    *                                                              *
    * <?sqljsParse@@YAHPAUsqljsDrdaAsCb@@PAUdb2UCinterface@@@Z>    *
    *                                                              *
    * <sqljspar.C:881>                                             *
    *                                                              *
    * ..                                                           *
    *                                                              *
    * ....                                                         *
    *                                                              *
    * </stacktrace>                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V97fp5                                            *
    ****************************************************************
    

Problem conclusion

  • Defect fixed in V97fp5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73541

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-28

  • Closed date

    2011-12-12

  • Last modified date

    2011-12-12

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

    IC73512

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

    IC73568

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC73541

Modified date: 12 December 2011