|
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) |
