Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

To migrate access-path statistics from the DB2 Navigator

 New console
  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.

    Note

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

  4. Click Migrate Statistics .

    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 for valid objects, and 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:

    •  identifies objects that migrated successfully.

    •  identifies objects that failed to migrate, and a message explains the failure. You can hover over the message to view 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  to repeat the migration.

      A new Results tab displays updated results.

 Classic console
  1. Click the DB2 Navigator perspective.
  2. Open or create an object view.
  3. Select one or multiple objects from the database, table space, table, or index list.

    Note

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

  4. Click Migrate Statistics , and then click either Migrate Statistics From  or Migrate Statistics To :
    • Select Migrate Statistics From to migrate statistics from the objects selected from the Results list. The object or objects that you want to update must already exist on the target subsystem.

    • Select Migrate Statistics To to migrate statistics to the objects selected from the Results list.

    Tip

    Alternatively, you can right-click the selected objects and select Tasks > Migrate Statistics > Migrate Statistics From or Migrate Statistics To.

  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 Db2 subsystem from the list of subsystems that are connected to the source Db2 subsystem.

    If you selected Migrate Statistics From, you are selecting the target Db2 subsystem.

    If you selected Migrate Statistics To, you are selecting 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 % or *).

    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 indicates all valid objects with , and invalid objects with .

  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  or Verify all .

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

    Tip

    Toggle to select or clear all objects.

    You can use the filter buttons to view specific object types, or to view only the valid or invalid objects.

  8. (optional) Click Next to view the Summary.
  9. To start the migration, click Finish.

    The results are displayed in a results table in the results tab in the Performance perspective:

    •  identifies objects that migrated successfully.

    •  identifies objects that failed to migrate, and a message explains the failure. You can hover over the message to view 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 this step:
    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, click  to refresh the objects list.

      Input parameters have been updated. The object list is stale .

    5. On the toolbar, click  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
Related topic


Was this page helpful? Yes No Submitting... Thank you

Comments