DB2 10 for z/OS Database Administrator — Question 50

Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

Answer options

• A. db2look
• B. db2advis
• C. db2expln
• D. db2exfmt

Correct answer: C

Explanation

The correct answer is C, db2expln, which specifically uses the Explain tables to provide details on the access plan. Options A (db2look) and B (db2advis) serve different purposes, such as generating DDL or providing recommendations, and D (db2exfmt) is used to format Explain output but does not directly access the Explain tables.