home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList