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?

1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement
2. Include EXPLAIN command in the embedded dynamic SQL statements

(Continued on next question...)

Other Job Interview Questions

• What do you accomplish by GROUP BY ... HAVING clause? ––
• How to increase table space in DB2?
• What is lock escalation?
• How does DB2 determine what lock-size to use?
• What is ACQUIRE/RELEASE in BIND?
• What is the picture clause of the null indicator variable? –
• How To perform Performance Tunning on COBOL-DB2 program ?
• What are the various locking levels available?
• How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
• How do you select a row using indexes in DB2?
• More...