DB2 FOR LUW / DB2FORLUW / 980 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* It takes much more time (around twice) on the current        * 
* version to execute the same export command with DEL type     * 
* than one on v8.2.                                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.8 FixPak 4                          * 
****************************************************************

DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Problem was first fixed in Version 9.8 FixPak 4

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.07.2011
08.08.2011
08.08.2011

9.8.