Migrating access-path statistics from the DB2 Navigator

To update objects with migrated access-path statistics, use the following procedure to select objects for statistics migration from the Db2 Navigator.

Related topics

Migrating statistics

To migrate access-path statistics from the Db2 Navigator

  1. Select the DB2 Navigator perspective.
  2. Open or create an object view.

  3. Select one or more objects from the database, table space, table, or index list.

    Important

    The table, table space, and index statistics that affect the access path are migrated for the selected objects.

  4. Click Migrate Statistics NW_file_arrow_right.png.

    Tip

    Alternatively, you can right-click the selected objects and select Migrate Statistics.

  5. Complete the following fields of the Parameters of the Migrate Statistics panel, and then click Next:

     

    Field

    Description

    Name

    Enter a name for the Migrate Statistics session.

    Include Table Statistics

    Select this box to migrate the table statistics for the selected object.

    This box is initially selected by default.

    Include Index Statistics

    Select this box to migrate the statistics of all indexes for the selected object.

    This box is initially selected by default.

    DB2 Connections

    Select the target Db2 subsystem from the list of subsystems that are connected to the source Db2 subsystem.

    Translation

    Define relevant translation rules for source objects that you are migrating so that they match the target objects. You can replace all occurrences of a specified string with another specified string.

    Do not use wildcard characters (including % and *).

    Clicking Next displays the Object List of the Migrate Statistics panel, which lists the tables, table spaces, and indexes to be migrated. The panel also indicates the source and target direction of the migration and displays a status icon beside each object. The status icon is NG_check_circle_dgreen.png for valid objects, and NG_exclamation_triangle_yellow.png for invalid objects.

  6. For each invalid object, take one of the following actions:
    • Click Back, and update the translation rules. Then click Next.
    • Select and update the invalid name. Then click Verify all.

  7. Clear any objects that you do not want to migrate.

    Tip

    Use the check box at the top of the first column to select or clear all objects.

    You can use the Filter list to view specific object types or to view only the valid or invalid objects.

  8. (Optional) To view the Summary, click Next.

  9. To start the migration, click Finish. The results are displayed in a table on the Result tab in the Performance perspective:

    • NG_check_circle_dgreen.png identifies objects that migrated successfully.
    • NG_exclamation_triangle_yellow.png identifies objects that failed to migrate, and a message explains the failure. You can hover over the message to view the details.

    The Migrate Statistics session is listed under Stats Migration in the Navigation pane in the Performance perspective.

  10. For any objects that failed to migrate, complete the following steps:
    1. Hover the cursor over the explanatory message to see details.
    2. Click the Parameters tab.
    3. Make the required changes to the Translation parameters.
    4. When the following message is displayed at the bottom of the panel, select the Object List tab to refresh the list of objects:Input parameters have been updated. The object list is stale.
    5. On the toolbar, click Migrate Statistics NW_file_arrow_right.png to repeat the migration. A new Results tab displays updated results.

Statistics migration updates the following Db2 statistics tables:

  • SYSTABLESPACE
  • SYSTABLES
  • SYSCOLUMNS
  • SYSCOLSTATS
  • SYSCOLDIST
  • SYSTABSTATS
  • SYSINDEXES
  • SYSKEYTARGETS
  • SYSKEYTARGETSTATS
  • SYSKEYTGTDIST
  • SYSKEYTGTDISTSTATS

 

 

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