Skip to Content

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).

New BMC Workbench console
  1. Click Options NW_gear.png.
  2. Select the Statistics Migration tab.
  3. Specify your preferences.
  4. Click OK.
Classic BMC Workbench 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 Workbench what to do if the migration process encounters an object containing a SQL error:

  • Selecting this option tells BMC Workbench to continue the migration.
  • Clearing this option tells BMC Workbench 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*

BMC Workbench for DB2 12.1