nerdexam
IBM

C2090-312 · Question #130

The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be used to gather the I/O…

The correct answer is C. START TRACE(PERFM) CLASS(3) PLAN(NEWBILLPL). See the full explanation below for the reasoning.

Question

The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be used to gather the I/O information needed for the objects in database NEWBILL?

Options

  • ASTART TRACE(AUDIT) PLAN(NEWBILLPL)
  • BSTART TRACE(IO) CLASS(ALL) PLAN(NEWBILLPL)
  • CSTART TRACE(PERFM) CLASS(3) PLAN(NEWBILLPL)
  • DSTART TRACE(ACCT) CLASS(1,2,3) PLAN(NEWBILLPL)

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    13% (4)
  • C
    77% (23)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice