This question is a regular feature in DB2 interview questions and answers for experienced, be ready to tackle it. If you want to generate a detailed report containing all of the explain data, you can execute the db2exfmt command in a sequence shown as follows: Enable the Explain facility by setting the current explain mode to EXPLAIN.  This will configure the CURRENT EXPLAIN MODE special register so that the EXPLAIN the facility can capture the explain information without executing the SQL statement: 1. SET CURRENT EXPLAIN MODE EXPLAIN; 2. Run the actual SQL statement in the same session:      db2 -tvf employee.ddl > employee.log 3. Disable the Explain facility by setting the current explain mode to NO:      SET CURRENT EXPLAIN MODE NO 4. Run the db2exfmt tool:     db2exfmt -d SAMPLE -g TIC -w -1 -s % -n % -# 0 -o employee.db2exfmt.out