So what is actually happening when I execute a query?

How you ever wondered what is really going on under the covers when you issue a simple SQL from your application? You might be surprised how much work is required to execute even a simple SQL. We’ll walk-trough each stage of query processing, from CONNECT, authentication trough SQL compilation down to reading bytes from disk and sending data back to the client. I’ll also show how we can utilize DB2 and OS tools to examine current state of database and our application/SQL.