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. To set migration options for the HSTATS command, use the Options NW_gear.png button in the DB2 Navigator perspective.

Related topic

Migrating-statistics

  1. Click Options NW_gear.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*