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 | |
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 | |
9.7.0.3 |