DB2 - Problem description
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) |