nerdexam
IBM

C2090-312 · Question #47

What is the result of the command -RECOVER POSTPONED CANCEL if the postponed-abort thread that you cancel was in the middle of a series of updates when DB2 abended?

The correct answer is B. The underlying page sets are placed in REFP restrictive state. See the full explanation below for the reasoning.

Question

What is the result of the command -RECOVER POSTPONED CANCEL if the postponed-abort thread that you cancel was in the middle of a series of updates when DB2 abended?

Options

  • AThe underlying page sets are stopped.
  • BThe underlying page sets are placed in REFP restrictive state.
  • CThe underlying page sets are placed in REORP restrictive state.
  • DNo restrictive state is set. It is your responsibility to ensure data consistency.

How the community answered

(30 responses)
  • A
    17% (5)
  • B
    73% (22)
  • C
    7% (2)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-312 Practice