|
Problem IC95224
|
Status: Closed |
CONTENTION DURING CONCURRENT LOADS CAUSED BY UNNECESSARY SMP PAGE SEARCHES |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
It is possible to observe a drop in performance when there are
many concurrently running tasks requiring new extents to be
allocated in a single tablespace.
DB2 searches the Space Map Pages to find free extents.
When there are no free extents tracked in these SMP pages, it is
possible that DB2 performs repeated searches on SMP pages known
to contain no free extent references.
This can lead to a contention for the different tasks requiring
a new extent, when there is a long chain of such SMP pages.
( e.g. in a large tablespace with a small extent size. ) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
Create a tablespace with a larger extent size thereby reducing
the number of SMP pages required.
Split tables into several table spaces. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
10.03.2014
10.03.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
