nerdexam
IBM

C2150-197 · Question #31

Which two db2 commands must be performed in order to collect information for calculating a db2 bufferpool hit ratio? (Choose two)

The correct answer is D. Get database snapshot E. Get monitor switches. bpc.612.doc/doc/bpc/t5tuneint_fine-tune_db.html

Maintenance and Troubleshooting

Question

Which two db2 commands must be performed in order to collect information for calculating a db2 bufferpool hit ratio? (Choose two)

Options

  • AUpdate dbm cfg using DFT_MON_BUFPOOL ON
  • BGet database manager configuration
  • CGet database configuration
  • DGet database snapshot
  • EGet monitor switches

How the community answered

(53 responses)
  • A
    11% (6)
  • B
    8% (4)
  • C
    4% (2)
  • D
    77% (41)

Explanation

bpc.612.doc/doc/bpc/t5tuneint_fine-tune_db.html

Topics

#DB2#bufferpool hit ratio#performance monitoring#database snapshot

Community Discussion

No community discussion yet for this question.

Full C2150-197 Practice