DB2 - Problem description
Problem IT37179 | Status: Closed |
OTF ENCODING FOR THE LARGE COLUMNS LEADS TO QUERY EXECUTION FAILS WITH SQL0954 . | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
OTF encoding causing out of application heap problems OTF encoding is still happening for a wide column ( varchar 29500 ) and causing SQL0954 stack: ======= -----Function + Offset------ _ZN17SqloMemController9dumpOnOOMEjb + 0x0574 sqloMemLogPoolConditions + 0x01d8 sqloGetMemoryBlockExtended + 0x1158 _ZN17sqloFastAllocator10allocBlockEmjPPvPKcmmj + 0x0134 _ZN23sqloFastThreadAllocator8allocMemEPKcmS1_mmPPvj + 0x00b4 _ZN7ibm_cde8services4Heap8allocMemEPKcmS3_mP13SQLO_MEM_POOLm _ZN7ibm_cde5types16VectorVarLenBaseINS0_12VarLenStringELNS0_ _ZN7ibm_cde5types10VectorBaseILNS0_12NullIndParamE1ELNS0_6Po _ZN7ibm_cde5types7HashSetINS0_12VarLenStringELNS0_9PartParam _ZN7ibm_cde5types7HashSetINS0_12VarLenStringELNS0_9PartParam _ZN7ibm_cde5query18EncodeAuxEvaluator7processINS_5types12Var _ZN7ibm_cde5query18EncodeAuxEvaluator26processInputsSynchron ====================== | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or higher * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or higher * **************************************************************** | |
Comment | |
Upgrade to 11.5.7 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.06.2021 01.12.2021 01.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |