Import SQL Performance Monitor data

Importing data for SQL performance monitors that were started without using System i Navigator or importing files from a monitor started on another system and brought to the current system is possible using the Import command.

To import SQL Performance Monitor data:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases and the database that you want to work with.
  3. Right-click SQL Performance Monitor and select Import.
  4. Specify the name you want to give the monitor in the Monitor Name field.
  5. Specify the name of the file containing the collected data. If you are importing a Summary monitor file, you will only need to specify the name of any one of the data files. The import function will determine what other files may exist, and their names.
  6. Specify the schema in which the files containing the data reside in the Schema field.
  7. Specify whether the type of monitor is Summary or Detailed.
  8. Click OK. The monitor will now show up in the SQL performance monitor window.

Once you have imported the data, you can Analyze the results. If you ran a detailed SQL performance monitor, you can choose to Run a Visual Explain.

Note: Detailed SQL performance monitor files will be converted to the current file format. Pre-V4R5 data files will be reformatted to meet V4R5 requirements before being imported.