Migrating statistics

For the selected objects, BMC AMI Command Center migrates the table, table space, and index statistics that affect the access-path.

For example, you can migrate production statistics to a test environment to view the actual access paths that the Db2 optimizer selects, without the cost of replicating the production environment.

You can select objects from a Results list in the DB2 Navigator perspective, or select objects included in a SQL Tuning session in the Performance perspective.

You can reuse a saved Migrate Statistics session. In the reused session, you can update objects with current access-path statistics, or change the source or target of the statistics.

You can use the Options  (In the new console, use ) button to set optional behaviors of the statistics migration feature.

For more information, view the Quick Course Workbench for DB2 - Migrating Statistics.