invispix 10x10
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT38893 Status: Closed

ADMIN_MOVE_TABLE WITH COPY_STATS MIGHT INVOKE LONG RUNNING RUNSTATS

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
To be able to copy statistics ADMIN_MOVE_MOVE with COPY_STATS
option might issue a long running runstats during SWAP phase.
With this change the sampling rate will get reduced to 0.00001.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ADMIN_MOVE_TABLE users that use COPY_STATS                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v11.5.7.1.                                    *
****************************************************************
Local Fix:
Avoid using COPY_STATS.
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* ADMIN_MOVE_TABLE users that use COPY_STATS                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v11.5.7.1.                                    *
****************************************************************
Comment
Fix included in Db2 v11.5.7.1
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.10.2021
14.12.2021
14.12.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10