|
Problem IT35047
|
Status: Closed |
POOR UPDATE PERFORMANCE AFTER MIGRATING TO V11.5.4
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
After migrating from v11.1 to v11.5.4, UPDATE statements went
from about 30 seconds to more than 1200 seconds.
Stack:
_ZN13SQLO_MEM_POOL12captureLatchEv
_ZN7ibm_cde8services4Heap7freeMemEPKcmPv
_ZN7ibm_cde8services16CdeOStringStreamlsERKS1
_ZNK7ibm_cde4data19UncodedTupleStorage11getAsStringEv
_ZNK7ibm_cde4data23StatementSavepointStack5printERNS_8services16
CdeOStringStreamEb
_ZNK7ibm_cde4data11InsertRange18printObjectMembersERNS0_17Object
PrinterBaseE
_ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE20readNextPag
eInternalILb0ELb0EEEPNS0_4PageEbRjRPNS0_11PageRequestERbSA_PbPKN
S0_14PageDescriptorE
_ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE12readNextPag
eERjPbPNS0_14PageDescriptorE
_ZN7ibm_cde5query21LoadColValueEvaluator20cdeFastLoadColValueTIN
S_5types7DecimalEEEvPKNS3_7TSNListEPKNS_4data13TableAccessorEPKN
S8_6ColumnERKNS3_22TypeAllocatorResourcesEmRbP10sqlz_valuePPNS3_
10ValUncodedEP17sqlriCdeStatementb
_ZN7ibm_cde5query21LoadColValueEvaluator19cdeFastLoadColValueEPK
NS_5types7TSNListEPKNS_4data13TableAccessorEPKNS6_6ColumnERKNS2_
22TypeAllocatorResourcesEmRbP10sqlz_valuePPNS2_10ValUncodedEP17s
qlriCdeStatementb
_ZN7ibm_cde4data12TupleBuilder15loadColumnValueERKNS0_6ColumnENS
_5types3TSNERNS0_13TableAccessorERNS5_22TypeAllocatorResourcesEm
P10sqlz_value
_ZN7ibm_cde4data13TableAccessor19decomposedUpdateRowENS_5types3T
SNES3_PK18sqlriCdeColumnListS6_RNS0_17TableIndexUpdaterERNS2_9Bi
tStringERNS2_22TypeAllocatorResourcesERNS2_10SQLWarningEmP10SQLI
_IXPCR
_ZN25cdeTableAccessorInterface19decomposedUpdateRowEmmPK18sqlriC
deColumnListS2_P26cdeDirectInsertTupleHandlelP10SQLI_IXPCR
_ZN12cdeInterface13performUpdateEmmPK18sqlriCdeColumnListS2_P26c
deDirectInsertTupleHandlelP10SQLI_IXPCR
_ZNSbIcSt11char_traitsIcEN7ibm_cde8services9AllocatorIcEEE7reser
veEm
_ZNSbIcSt11char_traitsIcEN7ibm_cde8services9AllocatorIcEEE6appen
dEPKcm
_ZN7ibm_cde8services16CdeOStringStream5writeEPKcmm
_ZN7ibm_cde4data29CdeOStringStreamObjectPrinter15printFieldValue
EPKcS3_
_ZN7ibm_cde4data17ObjectPrinterImplINS_8services16CdeOStringStre
amEE15printFieldValueEPKcRKS3_
_ZNK7ibm_cde4data11InsertRange18printObjectMembersERNS0_17Object
PrinterBaseE
_ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE20readNextPag
eInternalILb0ELb0EEEPNS0_4PageEbRjRPNS0_11PageRequestERbSA_PbPKN
S0_14PageDescriptorE
_ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE12readNextPag
eERjPbPNS0_14PageDescriptorE
_ZN7ibm_cde5query21LoadColValueEvaluator20cdeFastLoadColValueTIN
S_5types7DecimalEEEvPKNS3_7TSNListEPKNS_4data13TableAccessorEPKN
S8_6ColumnERKNS3_22TypeAllocatorResourcesEmRbP10sqlz_valuePPNS3_
10ValUncodedEP17sqlriCdeStatementb
_ZN7ibm_cde5query21LoadColValueEvaluator19cdeFastLoadColValueEPK
NS_5types7TSNListEPKNS_4data13TableAccessorEPKNS6_6ColumnERKNS2_
22TypeAllocatorResourcesEmRbP10sqlz_valuePPNS2_10ValUncodedEP17s
qlriCdeStatementb
_ZN7ibm_cde4data12TupleBuilder15loadColumnValueERKNS0_6ColumnENS
_5types3TSNERNS0_13TableAccessorERNS5_22TypeAllocatorResourcesEm
P10sqlz_value
_ZN7ibm_cde4data13TableAccessor19decomposedUpdateRowENS_5types3T
SNES3_PK18sqlriCdeColumnListS6_RNS0_17TableIndexUpdaterERNS2_9Bi
tStringERNS2_22TypeAllocatorResourcesERNS2_10SQLWarningEmP10SQLI
_IXPCR
_ZN25cdeTableAccessorInterface19decomposedUpdateRowEmmPK18sqlriC
deColumnListS2_P26cdeDirectInsertTupleHandlelP10SQLI_IXPCR |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.1 or higher *
**************************************************************** |
| Comment |
Upgrade to Db2 11.5.5.1 or higher |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.11.2020
31.03.2021
01.04.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
