DB2 - Problembeschreibung
Problem IC62130 | Status: Geschlossen |
SQLRA_HASH_LOC_OBJ HAS HIGH CPU USAGE AND RESULTS IN BAD PERFORMANCE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Empty dependency objects could accumulate in package cache, this will increase the searching time in the hash table link list. this is more likely to happen in a situation that uses a lot of Declared Global Temporary Tables With tprof (this is a performance tool on AIX to list the top functions with high CPU usage), customer can see some thing like this: Subroutine Ticks % Source Address Bytes ========== ===== ====== ====== ======= ===== .@99@1@sqlbFixPage(SQLB_FIX_CB*,int,unsigned int,int) 1340 1.40 sqlusBDSChannel.C 4a3490 630 .sqlra_hash_loc_obj(unsigned char*,unsigned int,unsigned char*,unsigned int,sqlra_anchor_dependency*,sqlra_cached_dependency**,sqlra_cac hed_dependency**) 656 0.68 xmlrpMemoryManagerDefault.C 2d80948 1f4 .sqlbSplatObject(SQLB_OBJECT_DESC*,unsigned int,SQLB_OBJECT_PAGE_RANGE*,SQLB_GLOBALS*)__fdpr_1 493 0.51 sqlcccmn.C 530180 1f8 .sqlbufix(SQLB_FIX_CB*,char,char) 487 0.51 sqlolio.C 4a1be8 478 .sqldEvalDataPred(SQLD_DFM_WORK*,unsigned long*,SQLD_DPRED*) 425 0.44 sqlolio.C 4916e0 1e0 .sqlbufix(SQLB_FIX_CB*,char,char)__fdpr_5 321 0.33 sqlolio.C 4a18f4 2f4 .sqldValFromFixed(SQLD_TCB*,SQLD_COLUMN*,SQLD_TDATAREC*,sqlz_val ue*,unsigned long) 248 0.26 sqlrl_catalog_vars.C 4e93e8 204 .sqldEvalDataPred(SQLD_DFM_WORK*,unsigned long*,SQLD_DPRED*)__fdpr_5 232 0.24 sqlolio.C 491c50 90 .sqldReadNorm(SQLD_DFM_WORK*,long)__fdpr_5 209 0.22 sqlolio.C 490024 3e4 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Unknown * **************************************************************** * PROBLEM DESCRIPTION: * * Empty dependency objects could accumulate in package * * cache,thiswill increase the searching time in the hash table * * linklist.this is more likely to happen in a situation that * * uses a lotofDeclared Global Temporary TablesWith tprof (this * * is a performance tool on AIX to list thetopfunctions with * * high CPU usage), customer can see some * * thinglikethis:Subroutine Ticks % * * SourceAddress Bytes========== ===== ====== * * ============= * * =====.@99@1@sqlbFixPage(SQLB_FIX_CB*,int,unsigned int,int) * * 13401.40 sqlusBDSChannel.C 4a3490 * * 630.sqlra_hash_loc_obj(unsigned char*,unsigned * * int,unsignedchar*,unsignedint,sqlra_anchor_dependency*,sqlra_c * 656 0.68 xmlrpMemoryManagerDefault.C2d80948 * * 1f4.sqlbSplatObject(SQLB_OBJECT_DESC*,unsignedint,SQLB_OBJECT_ * 4930.51sqlcccmn.C 530180 * * 1f8.sqlbufix(SQLB_FIX_CB*,char,char) 487 0.51 * * sqlolio.C4a1be8 * * 478.sqldEvalDataPred(SQLD_DFM_WORK*,unsigned * * long*,SQLD_DPRED*)425 0.44 sqlolio.C 4916e0 * * 1e0.sqlbufix(SQLB_FIX_CB*,char,char)__fdpr_5 321 * * 0.33sqlolio.C 4a18f4 * * 2f4.sqldValFromFixed(SQLD_TCB*,SQLD_COLUMN*,SQLD_TDATAREC*,sql * long) 248 0.26 sqlrl_catalog_vars.C * * 4e93e8204.sqldEvalDataPred(SQLD_DFM_WORK*,unsignedlong*,SQLD_D * 232 0.24 sqlolio.C491c50 * * 90.sqldReadNorm(SQLD_DFM_WORK*,long)__fdpr_5 209 * * 0.22sqlolio.C 490024 3e4 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 2. * **************************************************************** | |
Local-Fix: | |
n/a | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 2. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.07.2009 29.06.2010 29.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |