Migrating access-path statistics from a SQL Tuning session

To update objects with migrated access-path statistics, use the following procedure to select objects for statistics migration from a SQL Tuning session.

To migrate access-path statistics from a SQL Tuning session

  1. Select the Performance perspective.
  2. From a tuning session, either select a statement that has been explained or perform Explain on the statement.For more information, see Explaining-SQL-statements.
  3. Click Migrate Statistics NW_file_arrow_right.png.

  4. 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 source Db2 subsystem from the list of subsystems that are connected to the target 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 NW_check_circle_green.png for valid objects and NW_exclamation_triangle_orange.png for invalid objects.

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

  6. 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 the objects.

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

  7. (Optional) To view the summary, click Next.

  8. To start the migration, click Finish.The results are displayed in a results table in the Results tab in the Performance perspective:

    • NW_check_circle_green.png identifies objects that migrated successfully.
    • NW_exclamation_triangle_orange.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.

  9. 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 Objects 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 is displayed, which 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*