Skip to Content

 

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

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

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

    Success

    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 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.
Classic console
  1. Select the Performance perspective.
  2. From a tuning session, either select a statement that has been explained or perform Explain on the statement.See Explaining-SQL-statements.
  3. Click Migrate Statistics Stats-Migration_24x24.png, and then click either Migrate Statistics From Migrate-Stats-From_16x16.png  or Migrate Statistics To Migrate-Stats-To_16x16.png :
    • Select Migrate Statistics From to migrate statistics from the objects included in the SQL Tuning session. 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 included in the SQL Tuning session.

  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 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 g_gud_Check_16.png, and invalid objects with status-24-warning.png.

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

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

    Success

    Tip

    Toggle g_gud_AllSelected.png to select or clear all the objects.

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

  7. (Optional) Click Next to view the Summary.

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

    • g_gud_Check_16.png identifies objects that migrated successfully.
    • status-24-warning.png 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.

  9. 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 refresh-24.png to refresh the objects list.Input parameters have been updated. The object list is stale refresh-24.png.
    5. On the toolbar, click Stats-Migration_24x24.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*

BMC AMI Command Center for Db2 12.1