|
Problem IC68942
|
Status: Closed |
SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN INTRA_PARALLEL IS SET TO YES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If system is using SMP set-up (INTRA_PARALLEL db cfg parameter
IS SET TO YES) , then collecting section explain with actuals to
investigate poor query performance could return wrong row counts
when the same query is executed more then once.
Please, install this fix, or use information from one execution
of the query only. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* SMP systems only *
****************************************************************
* PROBLEM DESCRIPTION: *
* SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN *
* INTRA_PARALLEL *
* IS SET TO YES *
****************************************************************
* RECOMMENDATION: *
* install this fix *
**************************************************************** |
| Local Fix: |
use information from one execution of the query only |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN INTRA_PARALLEL
IS SET TO YES |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC68972
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.06.2010
16.09.2010
16.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
