|
Problem IT37147
|
Status: Closed |
CRASH ENCOUNTERED WHEN THERE IS A UNION/NLJN/ISCAN/SORT COMBINATION
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Internal codegen pushdown through Union logic does not work when
some Union columns are coming from lolepops above the Union.
This case needs to be detected and blocked.
Following stack is seen :
ossDumpStackTraceV98
_ZN11OSSTrapFile4dumpEmiP9siginfo_tPv
sqlo_trce
sqloEDUCodeTrapHandler
_Z22sqldFastFormatFixedVarP8sqeAgentP15SQLD_TDATAREC32PP10SQLD_V
ALUEP8SQLD_TCBj
_Z16sqlsFormatRecordP8sqeAgentP10SQLS_SLDESP10SQLS_SORTSPP10SQLD
_VALUE
_Z8sqlsinsrP8sqeAgentPcPhP12sqlri_vectorPP10SQLD_VALUE
_Z9sqlrsinsrP8sqlrr_cbP10sqlri_iudo
_Z8sqlrisr2P8sqlrr_cb
_Z13sqldDataFetchP8SQLD_CCBP8SQLZ_RIDmP7SQLI_CB
_Z8sqlischfP7SQLI_CBtj
_Z7sqlirdkP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBmP8SQLD_KEYP12SQLI_K
EYDATAP9sqli_scanPi
_Z14sqldIndexFetchP8SQLD_CCBP8SQLZ_RID
_Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP
12SQLD_ID_LISTP9SQLP_LSN8
_Z17sqlritaSimplePermP8sqlrr_cb
_Z8sqlriunnP8sqlrr_cbP10sqlri_stob
_Z8sqlrisetP8sqlrr_cb
_Z14sqlriNljnPipedP8sqlrr_cb
_Z14sqlriNljnPipedP8sqlrr_cb
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
_Z16sqlrr_smp_routerP8sqlrr_cb
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T
_Z21sqleProcessSubRequestP8sqeAgent |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* UNION WITH CORRELATED COLUMNS *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. Please, install this fix. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Local Fix: |
db2set DB2_TCG_DEFAULT_OPTIONS=?set disable_pushdown on?
or
db2set DB2_TCG_DEFAULT_OPTIONS=?set multi_stream_pushdown off?
Restart the instance after you have setup the above registry
variable, and REBIND the packages. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* UNION WITH CORRELATED COLUMNS *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. Please, install this fix. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Comment |
Upgrade to 11.1.4.7 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.06.2021
17.04.2022
17.04.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
