Re: Anyone got quick and dirty performance diag steps using VE or whatever?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Dave

You've maybe seen the discussions here lately on Visual Explain and 
all - to get the data, use 2 ways - in the job where you are going to 
run your SQL, do the STRDBMON command - prompt for parameters - be 
sure to get *DETAIL not *SUMMARY.

When you are done, you can import that as a monitor into iSeries 
Navigator - the database component - that has to be installed.

The 2nd way is, you can go to Navigator directly and have IT execute 
the queries - you need the run sql statement component - you can run 
statements AND get the monitor information there.

That's a good start - very simple is to put a job into debug mode - 
STRDBG in an interactive job or against a service job - a job other 
than the one you are in. That will put basic optimize information 
into the job log.

There is a manual on query optimization - it has lots of stuff on how 
to gather data and analyze it.

HTH
Vern

At 07:08 PM 4/21/2008, you wrote:

> Gang,
>
> I've got some SQL queries that I need to "performance evaluate" and 
> I'd like to use whatever method/tool that comes with V5R4 to do 
> it.   I am reading the manuals on On Demand SQL Performance Analysis 
> but would like a "net, net" step-by step so I can get these SQL 
> statements analysis started.  Any "Cliff's Notes" out there for this?
>
> Thanks in advance,
>
> Dave
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.