Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions