Re: SQL Performance Tuning/Embedded SQL

The same principles pretty much apply - get good indexes for JOINs and selectivity (WHERE clause).

There is still the "Database performance and query optimization" manual on Infocenter - look under Database there, then at the list of PDFs. Link is -

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/rzajq/rzajq.pdf

Lots of nice icons - in the section on access methods, they use the icons that are used in Visual Explain, which is the tool in navigator. Once in Visual Explain, make a right-click your best friend - lots of help and options there.

There are a couple Redbooks mentioned in the manual - I think Birgitta was involved with one - IIRC.

The ibmi cafe at developerworks (http://www.ibm.com/developerworks.com/ibmi) will have stuff on database in one of the sections - I saw a couple maybe-interesting articles in the technical library. Some are a few years old but may still have relevance.

HTH
Vern

On 10/10/2012 1:05 PM, Michael Ryan wrote:

Ok gang...I'm jumping in. I need some guidance on how to use the tools
in Navigator to tune embedded SQL programs. I'm updating my version of
Navigator to get to the latest. On 7.1. Fast new hardware.

Looking for manuals, experience, suggestions. I've done a little SQL
performance work, but it was under 5.4 and I'm sure things are
different/better now.

Thanks in advance...