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