Save SQL performance monitor history

If you no longer need a monitor, but would like to save the information captured by the monitor, you can save the a history of the monitor. When you save information from Analysis overview, the overview information for the monitor is saved to a column of a table. You can access this information at a later time to better understand changes to your queries over time.

To save monitor history:

  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. Click SQL Performance Monitor.
  4. Right-click the monitor you want to save history for in the right pane and select Analyze.
  5. From the Action menu, select Save to History.
  6. Specify a schema and table to save the information. You can view the contents of the selected table by clicking View Contents. If you select to save information to a table that does not exist, the system will create the table for you.

You can also save summary information for a specific summary query. Select a summary query from the Action menu or else select a summary from the Overview and select Summary. Then select Save to History from the Action menu.