|
Problem IT22684
|
Status: Closed |
SQL STATEMENTS EXECUTING AN INDEX SCAN WITH INTRA-PARTITION PARALLELISM ENABLED MIGHT RUN SLOW |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
SQL statements executing an index scan with intra-partition
parallelism enabled might run slower than necessary in Db2
version 11.1.2.2. This only happens when an exclusive start key
is specified such that the key does not exist in the index and
is greater than or smaller than all the keys in the index.
If db2trc is used to capture information about the SQL
statement, it will show that the entire scan is being performed
by a single sub-agent. The other sub-agents will call
sqliGetNxtRng and get SQLI_EOF. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users running on Db2 version 11.1.2.2 with *
* intra-partition parallelism enabled. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 version 11.1.3.3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
The problem is first fixed in Db2 version 11.1.3.3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.10.2017
15.03.2018
15.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
