|
Problem IT26621
|
Status: Closed |
UNDER RARE CIRCUMSTANCES, DB2 MAY ABEND WHEN A QUERY CONTAINS ANEXPRESSION THAT CAN BE MATCHED TO AN INDEXED EXPRESSION
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Under rare circumstances, Db2 may abend when a query contains an
expression that can be matched to an indexed expression.
Here is an example of the stack:
Stack #1 Signal #5
sqlnq_mch::getMatchingExprCol
sqlng_build_SQLD_VALS_obj
sqlng_build_TA_op
sqlng_process_f_iscan
sqlng_process_fetch_op
sqlngProcessLolepop
sqlng_process_sort_op
sqlngProcessLolepop
sqlng_build_thread
sqlng_scan_derived_table
sqlng_process_scan_op
sqlngProcessLolepop
sqlng_process_mate_op
...
sqlng_scan_derived_table
sqlng_process_scan_op
sqlngProcessLolepop
sqlng_process_mate_op
sqlngProcessLolepop
sqlng_process_pipe_op
sqlngProcessLolepop
sqlng_process_return_op
sqlngProcessLolepop
sqlng_build_thread
sqlng_main
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 v11.1 m4fp4 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.10.2018
27.11.2018
27.11.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
