IBM
C2090-312 · Question #178
As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2…
The correct answer is C. Issue the STOP command for the appropriate set of statistics. See the full explanation below for the reasoning.
Question
As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?
Options
- AIssue the ACCESS command with appropriate keywords.
- BIssue the ARCHIVE command with the appropriate keywords.
- CIssue the STOP command for the appropriate set of statistics.
- DIssue the ALTER command with the appropriate memory location.
How the community answered
(45 responses)- A7% (3)
- B2% (1)
- C80% (36)
- D11% (5)
Community Discussion
No community discussion yet for this question.