|
Problem IC78660
|
Status: Closed |
"RUNSTATS ... SET PROFILE ONLY" COMMAND LEADS SYSCAT.DATAPARTITIONS TABLES'S FIELDS TO BE UPDATED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
After execution of "RUNSTATS ... SET PROFILE ONLY" command,
SYSCAT.DATAPARTITIONS table's fields are updated. The same
behavior is also seen when running "RUNSTATS .... UPDATE PROFILE
ONLY".
These tables shouldn't be updated when "SET PROFILE ONLY" option
is used. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP6 or newer fix pack *
**************************************************************** |
| Local Fix: |
Run "RUNSTATS ... SET PROFILE" command right after "RUNSTATS ...
SET PROFILE ONLY" command. |
| 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 |
Problem First Fixed in DB2 Version 9.7 Fix Pack 6 |
| Workaround |
not known / see Local fix |
| Comment |
fixed in v97fp6 |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC85110
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2011
05.07.2012
05.07.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
|
 |
