Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC66276 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 / 950 - 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 execute    * 
* the same export command with DEL type than one on v8.2.      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.5 FixPak 6                          * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in Version 9.5 FixPak 6
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC66580 IC77545 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.02.2010
05.07.2010
23.09.2010
Problem solved at the following versions (IBM BugInfos)
9.5.
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.