|
Problem IC80723
|
Status: Closed |
RUNSTATS USING PROFILE DOES NOT USE SAMPLING ON INDEX STATISTICS COLLECTION. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When a profile is used for runstats, then if the profile was
created with "sampled" indexes , the sampling will not occur on
the indexes.
This can lead to slower than expected runstats execution.
e.g.
runstats on table db2inst1.staff for sampled detailed index
db2inst1.idx1 set profile only
followed by :
runstats on table db2inst1.staff use profile
will effectively internally execute :
runstats on table db2inst1.staff for detailed index
db2inst1.idx1; |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade the DB2 server to V9.7 Fix Pack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This problem has first been fixed in V9.7 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.01.2012
22.06.2012
22.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
