SQL advanced material needed

donevin · Posted: Mon Nov 23, 2009 7:11 pm

Hi

I'm sure someone in the forum will be able to help. I'm looking for a manual or any means that will take me beyond normal sql. I want to see what happens when an SQL command is resolved. I want to know what gets executed first, how, when and where does the sort takes place if necessary.

I want to see step by step what happens when an SQL query, from the simplest one-liner to the most complex query with triple joins, subqueries, unions and whatever else you might throw in there gets executed. I want to get down and dirty with SQL for DB2 on a z/OS mainframe. Can anyone please point me in the right direction. You just have to point, that's all. I'll do all the legwork required.

PeterHolland · Posted: Mon Nov 23, 2009 7:14 pm

Try the SAS site.

Anuj Dhawan · Posted: Mon Nov 23, 2009 9:11 pm

Try (...if I understood the question correctly):
1. Visual Explain for DB2 for z/OS.
2. Explain tools

dbzTHEdinosauer · Posted: Mon Nov 23, 2009 9:56 pm

IBM Redbooks Just Published

donevin · Posted: Tue Nov 24, 2009 11:34 am

Thanks very much guys for your speedy replies. I will go through all the materials you suggested. Much appreciated.

dick scherrer · Posted: Tue Nov 24, 2009 9:04 pm

Hello,

If you can find some "db2 tuning" material, you should find some of what you are looking for.