DB2 10 for z/OS Database Administrator — Question 45

Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

Answer options

• A. db2pd
• B. db2dart
• C. db2expln
• D. db2advis

Correct answer: C

Explanation

The correct answer, db2expln, is specifically designed to provide detailed explanations and recommendations for SQL statements, making it ideal for analyzing performance. The other options, while useful for different database management tasks, do not focus on generating design recommendations based on SQL in the package cache.