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

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.