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 |
****************************************************************
* 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. *
**************************************************************** |
