|
Problem IC73541
|
Status: Closed |
DB MAY ABEND WHILE EXECUTING AN OLAP QUERY WITH A BOUNDED WINDOW AGGREGATION RANGE GROUPING. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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_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 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 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Defect fixed in V97fp5 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73568
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.12.2010
12.12.2011
12.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
