Question: A DBA has run RUNSTATS for table space DB 1 . TS 1 multiple times with different RUNSTATS options. As a result, some of the

A DBA has run RUNSTATS for table space DB1.TS1 multiple times with different RUNSTATS options. As a result, some of the statistics are outdated.
How can the DBA clean up these obsolete statistics?
Question 25Select one:
A.
The DBA cannot explicitly remove the old statistics from the catalog; however, the next time a REORG is run, Db2 will clean them up and generate new values as requested via the utility control statement
B.
The only way to remove obsolete statistics from the catalog is to use SQL DML to manually update the catalog
C.
The DBA does not have to do anything special, because the RUNSTATS utility always cleans up all statistics information in the catalog before it generates and writes new statistics
D.
The DBA can use the RUNSTATS utility with the RESET ACCESSPATH option.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!