DB2 - Problembeschreibung
Problem IC73568 | Status: Geschlossen |
DB MAY ABEND WHILE EXECUTING AN OLAP QUERY WITH A BOUNDED WINDOW AGGREGATION RANGE GROUPING. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problembeschreibung: | |
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> | |
Problem-Zusammenfassung: | |
**************************************************************** * 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. * **************************************************************** | |
Local-Fix: | |
Lösung | |
Will be fixed in future releases | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.12.2010 31.03.2011 31.03.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |