Hi,

Does anyone have db2expln/dynexpln info or document link?
I can use it but do not understand the output generated by it.

For complex SQLs the output is just too large and complex and I do not know how to analyze the output.

Any help is appreciated.

Thanks,
j

Look in the Admin Guide: Performance reference manual for db2expln and db2exfmt. The second utility is a Format Tool for Explain.

You could also use the GUI Command Center, turn on the option to automatically generate an access plan, then run your queries and the graphically view the plans (I find this method very helpful since you can zero in fairly quickly where problems are).

HTH

Andy