IBM
C2090-312 · Question #169
Given this statement: RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH Which statement is FALSE?
The correct answer is A. It resets all real-time statistics (RTS) for DB1TS1. See the full explanation below for the reasoning.
Question
Given this statement:
RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH Which statement is FALSE?
Options
- AIt resets all real-time statistics (RTS) for DB1TS1.
- BIt resets all access path statistics for DB1TS1 in the catalog.
- CIt invalidates the dynamic statement cache for table space DB1TS1.
- DIt externalizes current access paths statistics for DB1 TS1 to HIST catalog tables.
How the community answered
(41 responses)- A80% (33)
- B12% (5)
- C2% (1)
- D5% (2)
Community Discussion
No community discussion yet for this question.