Sharing the results of tuning

You can export recommendations from advisors, access plan graphs, formatted SQL statements, and reports, so that other people can import them into their workspaces and view them.

Before you begin

The people who import this information must be using either the IBM® Data Studio full client or the IBM Data Studio administration client, version 3.1.1, and they must be able to connect to the database or subsystem that the SQL statement runs on.

Procedure

To share analysis results:

  1. Export the project that contains the results to share:
    1. If you ran the Statistics Advisor, tools, reports, or any combination of these features, close the workflow assistant by clicking the X symbol in its tab or by right-clicking the tab and selecting Close. The workflow assistant prompts you to save your work and the results to a project. Specify a project and click Save and Exit.
    2. In the Project Explorer, right-click the project that contains the results that you want to share and select Export.
    3. In the Export window, expand Query Tuner and select Projects. Export the project to your file system.
    4. Send the project to the people with whom you want to share it.
  2. View the results in a different client:
    1. Select File > Import.
    2. In the Import window, expand Query Tuner and select Projects. Import the project from the file system.
    3. In the Project Explorer, expand the project until you find the analysis result object that contains the information that you want to view.
    4. Double-click the analysis result, or right-click it and select Open.
    5. Select a connection to associate with the analysis result. The workflow assistant opens to the Review section.

Feedback