Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT05039 Status: Closed

SLOW PERFORMANCE OF BUILD PHASE OF LOAD AFTER FIXPACK UPGRADE.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Slow performance of Build phase of load after fixpack upgrade 
when the number of rows is at certain size.  With 10 million 
records, fp9 is faster than f7.  When using 36 million rows, fp9 
shows slower in the build phase. 
 
Rel 	SHEAPTHRES 	SHEAPTHRES_SHR 	SORTHEAP 
	SHEAPTHRES/sortheap 	SHEAPTHRES_SHR/sortheap 	Load Time 
	Build Time 
 
v97fp7 	7000000 	1000000 	250000 	  	28 	4 	2535 	  	3758 
v97fp7 	4000000 	1000000 	125000 	  	32 	8 	2588 	  	3873 
v97fp7 	2000000 	1000000 	62500 	  	32 	16 	2598 	  	3605 
v97fp7 	4000000 	4000000 	125000 	  	32 	32 	2587 	  	3758 
v97fp7 	2000000 	2000000 	62500 	  	32 	32 	2603 	  	3859 
 
v97fp9 	7000000 	1000000 	250000 	  	28 	4 	2469 	  	3962 
v97fp9 	4000000 	1000000 	125000 	  	32 	8 	2496 	  	3625 
v97fp9 	2000000 	1000000 	62500 	  	32 	16 	2511 	  	4345 
v97fp9 	4000000 	4000000 	125000 	  	32 	32 	2510 	  	3625 
v97fp9 	2000000 	2000000 	62500 	  	32 	32 	2535 	  	4112 
v97fp9 	5000000 	4000000 	125000 	  	40 	32 	2518 	  	4365
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Affects all server versions of DB2                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 11 or higher.                   * 
****************************************************************
Local Fix:
Solution
DB2 sorting code will perform more caching of small rows to 
amortize cost of spill operations. 
 
First fixed in DB2 V9.7 Fix Pack 11.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.10.2014
19.10.2015
19.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList
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.