Exam4Training

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?

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?
A .  Issue the ACCESS command with appropriate keywords.
B .  Issue the ARCHIVE command with the appropriate keywords.
C .  Issue the STOP command for the appropriate set of statistics.
D .  Issue the ALTER command with the appropriate memory location.

Answer: A

Exit mobile version