|
Problem IC66580
|
Status: Closed |
EXPORT COMMAND WITH DEL TYPE GETS ABOUT TWICE SLOWER AFTER DATABASE MIGRATION FROM V8.2 TO V9.5 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 FixPak 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.02.2010
27.09.2010
27.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
