IBM Support

IC73568: 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:                                              *
    * OLAP queries with SCALAG                                     *
    ****************************************************************
    * 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_operat
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1745>                                           *
    *                                                              *
    * <?sqlng_process_pipe_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operat
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1342>                                           *
    *                                                              *
    * <?sqlng_process_mate_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operat
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1732>                                           *
    *                                                              *
    * <?sqlng_process_pipe_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_operat
    * @@@Z>                                                        *
    *                                                              *
    * <sqlng_opt.C:1342>                                           *
    *                                                              *
    * <?sqlng_process_return_op@@YAHPAUsqlng_blk@@PAUsqlno_plan_oper
    * 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_compile
    * de@@FPAUsqlrr_cmpl_env@@HHPAPAVsqlnq_qur@@@Z>                *
    *                                                              *
    * <sqlnn_cmpl.C:3705>                                          *
    *                                                              *
    * <?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compile
    * de@@FPAUsqlrr_cmpl_env@@@Z>                                  *
    *                                                              *
    * <sqlnn_cmpl.C:498>                                           *
    *                                                              *
    * <?sqlra_compile_var@@YAHPAUsqlrr_cb@@PAUsqlra_cmpl_env@@PAEHGH
    * HHPAUsqlra_cached_var@@PAHPA_K@Z>                            *
    *                                                              *
    * <sqlra_cmpl.C:955>                                           *
    *                                                              *
    * <?sqlra_find_var@@YAHPAUsqlrr_cb@@PAUsqlra_cached_stmt@@Usqlra
    * 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@@PAUsqljDDMObjec
    * @PAUdb2UCinterface@@@Z>                                      *
    *                                                              *
    * <sqljspar.C:414>                                             *
    *                                                              *
    * <?sqljsParse@@YAHPAUsqljsDrdaAsCb@@PAUdb2UCinterface@@@Z>    *
    *                                                              *
    * <sqljspar.C:881>                                             *
    *                                                              *
    * ..                                                           *
    *                                                              *
    * ....                                                         *
    *                                                              *
    * </stacktrace>                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Will be fixed in future releases.                            *
    ****************************************************************
    

Problem conclusion

  • Will be fixed in future releases
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73568

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    980

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-29

  • Closed date

    2011-03-31

  • Last modified date

    2011-03-31

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

    IC73541

  • 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

  • R980 PSN

       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.8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 March 2011