RE: How to save Visual Explain

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Click on:

1) Databases-->SQL Performance Monitors
2) right-click on the dbmon file of interest and select 'Show Statements'
3) click on Retrieve
4) select the SQL statement you want to look at
5) click on Run Visual Explain

There's more to that interface, but this will get you what you want.
Thing to keep in mind is that when iNav says "SQL Performance Monitor" it
really means database monitor collection (i.e. STRDBMON command).

Good luck.

Elvis


Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com
 
-----Original Message-----
Subject: Re: How to save Visual Explain

I can't figure out how to pull that data in to VE though.  I don't see any 
File, Open option.

Rob Berendt