How do you do the EXPLAIN of a dynamic SQL state

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you do the EXPLAIN of a dynamic SQL statement ?

There are two methods to achieve this:
1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement
2.Include EXPLAIN command in the embedded by dynamic SQL statements

(Continued on next question...)

Other Job Interview Questions

• What is the database descriptor?
• What is CHECK PENDING ?
• I use CS and update a page. Will the lock be released after I am done with that page ?
• Which DB2 command is used to retireve environmental information?
• What is a composite index and how does it differ from a multiple index ?
• an I alter a table when other user is selecting some columns ...
• What is a clustering index?
• What is JOIN and different types of JOIN ?
• How can you quickly find out the number of rows updated after an update statement?
• What is Declaration Generator ( DCLGEN )?
• More...