|
Problem IC80018
|
Status: Closed |
INSTANCE MAY CRASH ON CREATION OF AN MQT WHERE THE MQT DEFINITION CONTAINS THE FETCH FIRST N ROWS CLAUSE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In a rare case, MQT creation statement which contains the FETCH
FIRST N ROWS clause causes instance to crash with SIG #11.
It dumps FODC output and stacks lists like below:
change_to_lower_box__9sqlnq_qunFP9sqlnq_qtbP12sqlnq_colmap15sqln
q_typeCheck
change_to_lower_box__9sqlnq_qunFP9sqlnq_qtbP12sqlnq_colmap15sqln
q_typeCheck
change_to_new_box__9sqlnq_qunFP9sqlnq_qunib
insert_between__9sqlnq_qtbFP9sqlnq_quniRiRP9sqlnq_qun
insert_box__9sqlnq_qunF13sqlnq_oprTypeiT2
insert_box__9sqlnq_qunF13sqlnq_oprTypeiT2@glue130A
process_multiple_ffnr__9sqlnq_qurFv
sqlnq_postParse__FP9sqlnq_qurP3loc
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiPUl
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb
sqlra_get_var__FP8sqlrr_cbiT2bPbT5
sqlri_ddl_get_section__FP8sqlrr_cb
sqlri_ddl_common__FP8sqlrr_cb
sqlriddl__FP8sqlrr_cb
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm
sqlrr_execute_immediate__FP8sqlrr_cbi
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo
sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* UNIX *
* WINDOWS *
****************************************************************
* PROBLEM DESCRIPTION: *
* In a rare case, MQT creation statement which contains the *
* FETCH *
* FIRST N ROWS clause causes instance to crash with SIG #11. *
* *
* It dumps FODC output and stacks lists like below: *
* change_to_lower_box__9sqlnq_qunFP9sqlnq_qtbP12sqlnq_colmap15 *
* sqln *
* q_typeCheck *
* change_to_lower_box__9sqlnq_qunFP9sqlnq_qtbP12sqlnq_colmap15 *
* sqln *
* q_typeCheck *
* change_to_new_box__9sqlnq_qunFP9sqlnq_qunib *
* insert_between__9sqlnq_qtbFP9sqlnq_quniRiRP9sqlnq_qun *
* insert_box__9sqlnq_qunF13sqlnq_oprTypeiT2 *
* insert_box__9sqlnq_qunF13sqlnq_oprTypeiT2@glue130A *
* process_multiple_ffnr__9sqlnq_qurFv *
* sqlnq_postParse__FP9sqlnq_qurP3loc *
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P *
* 14sq *
* lrr_cmpl_enviT7PP9sqlnq_qur *
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P *
* 14sq *
* lrr_cmpl_env *
* sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14S *
* QLP_ *
* LOCK_INFOP16sqlra_cached_varPiPUl *
* sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_ *
* idUi *
* T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12 *
* _P14 *
* SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb *
* sqlra_get_var__FP8sqlrr_cbiT2bPbT5 *
* sqlri_ddl_get_section__FP8sqlrr_cb *
* sqlri_ddl_common__FP8sqlrr_cb *
* sqlriddl__FP8sqlrr_cb *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm *
* sqlrr_execute_immediate__FP8sqlrr_cbi *
* sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo *
* sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6. *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
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 |
First fixed in Version 9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.11.2011
05.02.2012
05.02.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
