|
Problem IC80158
|
Status: Closed |
DB2PD -RUNSTATS SHOWS INCORRECT "END TIME" FOR A USER RUNSTATS IF A SUBSEQUENT AUTOMATIC RUNSTATS IS DONE TO THE SAME TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When you issue a RUNSTATS command, you can check its progress
with the -runstats option of db2pd. The information continues
to be available after the RUNSTATS completes. If automatic
statistics collection subsequently processes the same table, the
end time information is incorrectly modified. If you use db2pd
-runstats to review your collection again, you might think the
collection took longer than it really did. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* When you issue a RUNSTATS command, you can check its *
* progress *
* with the -runstats option of db2pd. The information *
* continues *
* to be available after the RUNSTATS completes. If automatic *
* statistics collection subsequently processes the same table, *
* the *
* end time information is incorrectly modified. If you use *
* db2pd *
* -runstats to review your collection again, you might think *
* the *
* collection took longer than it really did. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 Fix Pack 6. *
**************************************************************** |
| Local Fix: |
Review the statistics logs for information on statistics
collections. |
| 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 was first fixed in Version 9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC80160
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.12.2011
05.06.2012
05.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
|
 |
