Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Setting statistic migration options

Use the following procedure to set options for migrating access-path statistics. You can set these options from the Performance perspective, the DB2 Navigation perspective (Classic Console only), or the Migrate Statistics panel (Classic Console only). To set migration options for the HSTATS command, use the Options NW_gear.png button in the DB2 Navigator perspective.

Related topic

Migrating-statistics


New console
  1. Click Options NW_gear.png.
  2. Select the Statistics Migration tab.
  3. Specify your preferences.
  4. Click OK.
Classic console
  1. Click Options configuration-24.png.
  2. Select the Statistics Migration tab.
  3. Specify your preferences.
  4. Click OK.

You can set the following options:

Option

Description

Timestamp to use for STATSTIME

Specifies the timestamp used to update STATSTIME on the target object:

  • Select Current to use the machine time.
  • Select Source to use the source object timestamp.

Continue on SQL Error

Tells BMC AMI Command Center what to do if the migration process encounters an object containing a SQL error:

  • Selecting this option tells BMC AMI Command Center to continue the migration.
  • Clearing this option tells BMC AMI Command Center to exit the migration.

Delete statistics before migration

Specifies whether to delete all previous instances of the target table spaces' SYSCOLDIST, SYSTABSTATS, SYSKEYTGTDIST, and SYSKEYTGTDISTSTATS tables before inserting the migrated statistics row or rows


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*