What is the DB2 design advisor?
Answer(s)
- The DB2 design advisor is a tool that can help you improve your workload performance. Thetool asks you questions about your workload and other options it should take into account, andthen recommends performance changes to your database.
- The DB2 design advisor is a help desk facility that is available to all licensed DB2 owners thathave paid their maintenance agreements with IBM. The tool is a Web site that guides youthrough the design of your database, with the DBA responding to a series of questions. Itproduces a database schema that allows for quick database creation.
- The DB2 design advisor is a tool that automatically analyzes your running database andcontinuously makes changes to your database, so that the database is running at peakperformance.
- DB2 has no design advisor tool.
Correct Answer
The DB2 design advisor is a tool that can help you improve your workload performance. Thetool asks you questions about your workload and other options it should take into account, andthen recommends performance changes to your database.