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 IC66580 Status: Geschlossen

EXPORT COMMAND WITH DEL TYPE GETS ABOUT TWICE SLOWER AFTER DATABASE
MIGRATION FROM V8.2 TO V9.5

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
After database migration from v8.2 to v9.5, we can find that 
it takes much more time (around twice) on v9,5 to execute the 
same export command with DEL type than one on v8.2. 
 
  If we take "db2trc on -perfcount -t" on the client, we can see 
we spends much process time in sqlovsfh(), and in sqloxltc_app() 
and sqloxult_app as well which are newly added on v9.5 like 
below. 
 
awk '{ printf( "%10d  %6d sec  %9d nano  %s\n", $1, 
substr($2,2), $4, $6 ); }' v95db2bp.perf | sort -rk2,4 | less 
 
         1     167 sec  983439929 nano  clp_bp_exe 
         1     167 sec  983433360 nano  clpbp_exe_db2Export 
         1     167 sec  982749018 nano  db2Export 
         1     167 sec  975489627 nano  sqluexpm 
         1     167 sec  285409572 nano  sqlue_fetch 
    100000     152 sec    5049271 nano  sqluecwr 
  34200000     122 sec  100032017 nano  sqlofwrt 
   9300000     107 sec  970578949 nano  sqlueccf 
  34200001      90 sec  278655887 nano  sqlovsfh 
  34300022      18 sec  734483012 nano  sqloxltc_app 
  34300022      17 sec   48213006 nano  sqloxult_app 
    100018      14 sec  508884639 nano  sqlacall 
    100003      13 sec  374501134 nano  csmFetch 
    100003      13 sec   92384757 nano  sqlak_callbDrdaOutput 
...
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* It takes much more time (around twice) on v9,5 to executethe * 
* same export command with DEL type than one on v8.2.          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.7 FixPak 3                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.7 FixPak 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.02.2010
27.09.2010
27.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList