nerdexam
IBM

C2090-600 · Question #68

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

The correct answer is B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE. See the full explanation below for the reasoning.

Question

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

Options

  • ASet the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort
  • BSet the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE
  • CSet the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the
  • DUse AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or

How the community answered

(54 responses)
  • A
    2% (1)
  • B
    80% (43)
  • C
    6% (3)
  • D
    13% (7)

Community Discussion

No community discussion yet for this question.

Full C2090-600 Practice