|
Problem IC91299
|
Status: Closed |
ASYNCHRONOUS RUNSTATS REQUESTS MIGHT BE LOST IN DPF ENVIRONMENTS FOR TABLES THAT DO NOT RESIDE ON THE CATALOG DATABASE PARTITION |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When the real time statistics (RTS) feature is enabled for a
database, db2agent EDUs compiling SQL statements can
synchronously collect statistics and make asynchronous runstats
requests to be satisfied by the background RTS daemon. The
asynchronous requests might be lost in DPF environments for
tables that do not reside on the catalog database partition.
Whether the problem will occur is not deterministic. If the
problem occurs, until statistics are refreshed by a subsequent
synchronous or asynchronous collection, the query optimizer will
have less accurate statistics when making access plan decisions. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DPF *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version10.1 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
This problem is first fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.04.2013
17.10.2013
17.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
