nerdexam
IBM

C2090-312 · Question #111

The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. To provide…

The correct answer is D. SYSIBM.SYSTABLESPACESTATS. See the full explanation below for the reasoning.

Question

The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?

Options

  • ASYSIBM.SYSCOPY
  • BSYSIBM.SYSSTATS
  • CSYSIBM.SYSTABLES
  • DSYSIBM.SYSTABLESPACESTATS

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    11% (4)
  • D
    80% (28)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice